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...
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...
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...
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...
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
Hi all,
new to coldfusion and am getting the below error
An expression that began on line 2589, column 99.
Your expression might be missing an ending "#" (it might look like #expr ).
on the following code
The error occurred in C:\Inetpub\Wwwroot\SecurApp\TrackTrace\TraceResults.cfm: line...
Just to let you know, I resloved the issue by getting her to install the latest microsoft updates for outlook and this fixed her issue
Thanks again for the help
Regards
Aiden
Stewart,
I have gotten her to check this, and she isnt been asked the question but I have requested her IT to re-install outlook on her pc to see if this resolves the issue. I will let you know, thanks for your help
Regards,
Aiden
Stewart,
I cant say for definete which line it is occuring on as when i log on to check , it works on the pc I remote desktop to.
The date is a date stored on the application not on the computer system.
Regards,
Aiden
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.