₦airaland Forum

Welcome, Guest: RegisterLoginWith GoogleTrendingRecentNew

Stats: 3,325,030 members, 8,419,999 topics. Date: Thursday, 04 June 2026 at 09:09 AM

Toggle theme

JustJoined's Posts

Nairaland ForumJustJoined's ProfileJustJoined's Posts

1 (of 1 pages)

ProgrammingRe: Test Your Knowledge Of Excel On This by JustJoined(m): 9:34am On Aug 02, 2008
This short script in Visual FoxPro might help


**--------------This creates a folder on you c: drive for all the work

m.DataDrive = 'c:'
m.DataPath = '\nairaland'

SET DEFAULT TO c:

IF !DIRECTORY(m.DataDrive)
MESSAGEBOX('Please make sure you have a C: drive mapped')
QUIT
ELSE
IF !DIRECTORY(m.DataDrive+m.DataPath)
MD nairaland
CD nairaland
ENDIF
ENDIF

**----------------Creates a temporary VFP table
CLOSE ALL
CREATE TABLE tmpDUMP FREE (fldName c(100), fldValue c(200))

**----------------Appends from excel sheet
APPEND FROM ? TYPE XL5 SHEET sheet1


**----------------If the excel sheets are uniform and data placed same way in all the documents
**----------------You can do this,
DIMENSION rowval(RECCOUNT())
x = 1

GO TOP
SCAN WHILE !EOF()

rowval(x) = ALLTRIM(fldValue)
x = x+1

ENDSCAN


**------------------------You can do whatever you want here e.g.
**------------------------Insert into SQL Server or reformat and export
IF EOF()
m.cnn = [DRIVER=SQL SERVER;SERVER=] + "127.0.0.1" + [;DATABASE=nairaland;uid=sa;pwd=nairaland]
lnConnHandle=SQLSTRINGCONNECT(m.cnn)

vSQL = "Insert Into dbo.nairalandSample (lastname,firstname,sex,age,country) Select "+"'"+rowval(1)+"','"+rowval(2)+"','"+rowval(3)+"','"+rowval(4)+"','"+rowval(5)+"'"
=SQLEXEC(lnConnHandle,vSQL ,'xx')
ENDIF
ComputersRe: MTN Wireless Internet For Laptops? by JustJoined(m): 3:28pm On Oct 20, 2007
The MTN sharkpod,
As a very mobile person I have had to acquire one and, these are my immediate comments,

1. It's okay for people who travel a lot and need to be online almost every time. I have been able to use it everywhere there is GPRS, Lagos, Ogun, Abuja, Enugu, Owerri, Ibadan, Ekiti to mention a few
2. It allows FTP and other basic functionality but does not allow remote desktop connection.
3. If you are paying as you use, you must be very buoyant. The flat N12k / month in my opinion is more economical.
4. I think it is slow but hey, I am able to connect to SQL Server over the net and pull down 100,000 records from a table with 10 fairly large fields.

I hope this is helpful.
Jobs/VacanciesTwo Web Designers Needed by JustJoined(op): 8:04pm On Oct 19, 2007
Two Creative Web Designers required. Renumeration between N720K and N1.4m per anum. Interested readers should leave their number(s) in the post and would be contacted.
Nairaland GeneralRe: Today Is My Birthday! by JustJoined(m): 12:16pm On Oct 14, 2007
I just joined and Today is my birthday too! 

Anyway happy birthday and thank you for reminding me that I am a year older today.

1 (of 1 pages)