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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DominicProgrammer

    Response txt to Json string

    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
  2. DominicProgrammer

    Response txt to Json string

    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...
  3. DominicProgrammer

    vfp to 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...
  4. DominicProgrammer

    vfp to json

    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": [ {...
  5. DominicProgrammer

    vfp to json

    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...
  6. DominicProgrammer

    Creating a JSON from VFP

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

    Creating a JSON from VFP

    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"...
  8. DominicProgrammer

    Creating a JSON from VFP

    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...
  9. DominicProgrammer

    Inserting Data into Sql from Vfp

    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
  10. DominicProgrammer

    Inserting Data into Sql from Vfp

    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...
  11. DominicProgrammer

    Inserting Data into Sql from Vfp

    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')...

Part and Inventory Search

Back
Top