SORRY TO ADD RECORDS function Main() USE Fusion VIA "ADORDD" TABLE "patients" MYSQL FROM "127.0.0.1" USER "fusion" PASSWORD "fusion" ALIAS "Patients" go bottom ncode:=Patients->code +1//primary key, IF YOU HAVE ANY PROBLEM USE DATABASE S...
Jeff (sorry my english is very bad) So add record First, if you database contain a primary key. you have update this field Your example suppose that primary key name is "CODE" #include "FiveWin.ch" #include "ADORDD.ch" REQUEST ADORDD Function Main() USE Fusion VIA "...
I found the function ADO_APPEND() in ADORDD.PRG but I don't understand why it cannot use. It shows the error "Unresolved external '_HB_FUN_ADO_APPEND'".
Hi Dutch, This is what I did: #include "FiveWin.ch"#include "ADORDD.ch" REQUEST ADORDDFunction Main() USE Fusion VIA "ADORDD" TABLE "patients" MYSQL FROM "127.0.0.1" USER "fusion" PASSWORD "fusion" ALIAS "Patients&...
I do not use ADORDD normally. I use ADO directly. But for this post I tested with ADORDD of xharbour. I made only one small change in the adordd.prg. Changed the driver from 3.51 to 5.1. ADORDD is working fine for me. I am able to add rows and modify rows. Unless opened in exclusive mode, we should ...
Thanks Armando and Anserkk for you idea of using ADO directly, however, currently I would like to stick with the xbase style control over the database. I really don't have the time to learn the ADO format :( Does anyone know how to allow access to adding / modifying the data via an ADORDD connection?
I can open MySql with ADORDD as Jeff example BUT cannot append or delete or modify record. It alway shows an error. Anyone could help and example for these cases?
Dear Mr.Jeff, I can browse the database but I get the same error when I try to add/modify the data. If you have VARCHAR columns in the Table and if you try to add a Character type data without an Rtrim/Alltrim, then you may get error. That is just one of the reason and it is a very common mistake. T...