Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  Other Topics  VBScript and SQL Insert with Foxpro DBFs

Author  Topic  Michelle Starting Member 1 Post Posted - 2000-11-02 : 10:16:06 I am writing in VBScript for my ASPs and I am trying to use the SQL Insert from one foxpro table into another the from fields are read using the Recordset but when I try to add in Logical and Memo type fields, no matter what syntax I use around the fields it returns an error My sql statement is as follows: stringSQL = "INSERT INTO z_ucalls ( 'uc_log','uc_enginer','uc_stime','uc_etime','uc_ampm','uc_account','uc_memo','uc_amount','uc_bookd','uc_contact','uc_name','uc_addr1','uc_addr2', 'uc_addr3', 'uc_addr4', 'uc_pstcode', 'uc_teleno', 'uc_charge') " &_ "VALUES ( '" & strLognumber & "' ,'" & strEngineer & "', '" & strStime & "', '" & strEtime & "','strAmpm','" & strAccount & "', 'strMemo' ," & iAmount & ", Date(), '" & strContact & "', '" & strName & "', '" & strAddr1 & "', '" & strAddr2 & "', '" & strAddr3 & "', '" & strAddr4 & "', '" & strPstcode & "', '" & strTeleno & "', bolCharge )" The problem with this is the bolCharge field which is Logical I have tried 'bolCharge' , " & bolcharge $ " , '" & bolCharge & "' Please can you help ?