Recent content by AidenMc

Fred, If you store recno() to mrecno, then on the next line type in replace custid with mrecno, that will do it for you. Although it would be best if you have a table that you use specifically for this. For example if you create a table called custid, with just a numeric field in it. Then...

Danyd, Are you looking for a routine to increment the number ?

Ilya, The following works in dbase for dos maybe you can use this code to do the same for visual dbase * WWAIT * User defined pause routine to nearest 100th of a second centisecond). * Pass the delay in centiseconds as a parameter. (Max is 23:59:59.00 * Program continually looks at...

Olaf, Thanks for that , it's been a great help Cheers Aiden

All, I have been asked to see if VFP supports/can import files that will be in Cantonese. I am afraid thats all the information I have been given ie no file format or layout, just whether or not we would be able to use VFP/dbase to import the files into our systems. Has anyone done this...

All, Have had a strange request in work , does anyone know if dbase can handle cantonese symbols or characters ? Thanks Aiden

Guys, Thanks for all your help Olaf, I tried you sample and it worked without the $, only problem I have left with that is the original programmer in the company, had a naming convention for the tables so they all start with $, but its a minor issue the major one was been able to open a...

Mike, I think I am still missing a step or else its my location below is my code lcCmd = "SELECT * FROM $groupfx" lnHandle = sqlstringconnect('driver=Microsoft dBase Driver (*.dbf);dbq=R:\') lnReply = SQLEXEC(lnHandle, lcCmd, "MyCursor") IF lnReply > 0 SELECT MyCursor BROWSE ENDIF...

Thanks Mike, I will give this a try and yes you are correct R is the location of the dbase files. Just on that using select * from table ( that wont convert the dbase table to foxpro ? ) . I will let you know how I get on, Thanks Again Aiden

Mike, There is no reason but I dont have too much experience using ODBC. So far in my test program the following code is working lnHandle = sqlstringconnect('driver=Microsoft dBase Driver (*.dbf);dbq=R:') if lnHandle < 0 * handle error RETURN ENDIF lnhandle does return a value greater...

thread184-1138322 In relation to the above thread, I am attempting to do the same and I am not really getting anywhere with it, has anyone managed to do this successfully. Again like bill these are live dbase tables and I need to be able to query them from foxpro without changing the structure...

You could try the freeware from http://www.sharewareconnection.com/software.php?list=Visual+Dbase+Full+Software

Sorry Ilya, I meant to ask whether you were running over novell or not, if you are you could use filer to restore the mdx, as far as I am aware you wont be able to get it back using the header and fopen() but thats not to say you can't Aiden

Ilya, Just wondering what version of dbase you are using, if you could let me know Thanks

Hi all, I worked years ago with dbase, I need to find about dbase 5 where is the best area to get information on this Regards, Aiden