ADORDD

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
AUGE_OHR
Posts: 2060
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany

Re: ADORDD

Post by AUGE_OHR »

hi,

YES, that way INSERT INTO work, THX

now i have a small Problem : how when empty Date :idea:
i try "0" or "1" and get 31.12.1899 but i like to have it empty

---

now while both work i can compare time.
DBF 3 MB, 16 Fields, 220134 Records need
INSERT INTO -> 160 Sec.
RecordSet -> 40 Sec
libxlsxwriter.dll -> 20 Sec
but i have no working 64 Bit libxlsxwriter.dll so i will use ADO RecordSet
have fun
Jimmy
User avatar
AUGE_OHR
Posts: 2060
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany

Re: ADORDD

Post by AUGE_OHR »

hi,

this line

Code: Select all

    oColumn:Attributes := adColNullable
is bad for Type "L" so delete it
have fun
Jimmy
Post Reply