Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
convert dbase expr. func. to sql server
'::risk_id::' is the name of a variable that references a field in the db that is called risk_id and contains data in the form - 000000, 000002, 000023, 000184, 004982, 098263, of which we currently only use the last 5 characters. The form can accept the input of risk_id as 5, or 6...- phillipu
- Post #5
- Forum: Microsoft: FoxPro
-
convert dbase expr. func. to sql server
The updated sql you gave me produces this error - Description: 'val' is not a recognized function name. Number: -2147217900 (0x80040E14) Source: Microsoft OLE DB Provider for SQL Server- phillipu
- Post #3
- Forum: Microsoft: FoxPro
-
convert dbase expr. func. to sql server
Hi, I have inherited some legacy dbase .dbf files and the associated sql for them, I have been tasked with converting the .dbf's to sql server (done) but what I'm stuck on is how to convert or rewrite the sql to work with sql server. The current sql uses several dbase expression functions that...- phillipu
- Thread
- Replies: 5
- Forum: Microsoft: FoxPro
