Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec
Message
From
17/12/2003 16:20:05
 
 
To
16/12/2003 14:38:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00859608
Message ID:
00860106
Views:
16
Hey Paul,

What do you get in AErrors()?

Aloha,

James
>Hi probably an easy question for someone that has been doing this for awile. I have a routine that scans a directory and then converts WAV file to MP3's then i need to load the info into a SQL server table. Anyways below is a snippet of the code ..x = -1 so it is not updating the sql table.
>
>
>
>lcsql = 'Insert into tbl_Mp3 (fk_folderID, filename, ConvertDate, filedate, filesize) VALUES(' + alltrim(config.folder_id)+ ',' + lawavs(j,1) +','+ dtoc(date())+ ',' + dtoc(lawavs(j,3))+ ','+ alltrim(str(lawavs(j,2))) + ')'
>
>x = SQLEXEC(nHandle,lcsql)
>?lcsql
>?x
>
>thanks
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform