General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only