Search results for query: *

HI Mike & Chris. Thank you guys for your valued inputs, I really appreciate it. I have used the Nfjson solution and i can now proceed with the API link & execution. Dominic

lcUrl = "http://192.168.1.100:5000/EsdApi/deononline/signinvoice" && local pc IP loXmlHttp = Createobject("Msxml2.ServerXMLHTTP.6.0") llNull = loXmlHttp.Open( "POST" , lcUrl, .F. ) &&..open connection loXmlHttp.setRequestHeader("Content-Type","application/json") && you are sending in JSON...

Hi Chris. You are a savior, this is all i had to do. CODE lnScanningRecord = 0 Scan lnScanningRecord = lnScanningRecord+1 ... ...IIF(lnScanningRecord < Xreccs2,',','')... Endscan It worked and now i can post my entire desktop payroll into Mysql hosted online. Thanks a bunch buddy...

HI Chris Thanks for your feedback much appreciated, i have actually set the employees.txt bug, how may i rewrite it to prevent the last comma? this is my expected json file: [ { "employee_id": "BSC001", "period": "30/06/2023", "transactions": [ {...

Hi Good guys, wud someone assist me track this foxpro code out, why is the json file coming with a "," @ the end of the file even if its coded not to? ** paytranf Select transfile pack Set Deleted On Set Relation To Code Into Type GO top SET ORDER TO empcode Count To Xreccs2...

Hi Martinaj. Yours worked. Thanks thanks thanks ,About the Json invalidation i will try work on it. Regards. Dominic

Hi Jindrova. Thanks for your reply, i appreciate, that duplicate is what i want to solve, help me, i have attached the Db too. This is the JSON result i envision. <'{"CallBackUrl":"http://192.168.0.5:8128/kekaapi/invoices", "InvoiceNumber":,"910641", "TotalInvoiceAmount":,"0"...

Hi Experts. I have an issue here trying to create a json like txt file so i can use in in API link but i cant get the products coming in records [there are only 2 records in that temp table] why does the records duplicate in the ItemDetails object ? Kindly assist me. Thanks in advance: Close...

Hi Olaf. Thanks A Bunch, your solution so simple and it worked so well and av already completed the task uploading over 10,000 records into Sql server Erp. Thanks So much. Dominic

Thanks Soo Much Tamar. Its very True what you say,i actualy forgot to remove those lines: En Way for now Its a one time update from a vfp table into sql, about 300 records. I will appreciate if you can show me how to insert that data into sql, the vfp table is a free table, i use ODBC to make...

Hi Friends. Kindly assist me post this data from vfp table to sql server. "CLOSE ALL USE timback IN 0 ORDER dc gnConnHandle=SQLCONNECT('SQL',') && proper(mlogname) IF gnConnHandle <= 0 MESSAGEBOX('Could not Connect to the SQL Server.', 16, 'SQL Server Error')...