Re: [Lazarus] create table doesn't store

2023-02-09 Thread Larry Dalton via lazarus
That worked, Michal. Thanks! Sent from my iPhone > On Feb 9, 2023, at 10:42, gabor via lazarus > wrote: > > W dniu 2023-02-09 o 16:32, Larry Dalton via lazarus pisze: >> This code says it creates TEST_TABLE, but it doesn't store it in the >> database. >> If I click the button once, it appare

Re: [Lazarus] create table doesn't store

2023-02-09 Thread gabor via lazarus
W dniu 2023-02-09 o 16:32, Larry Dalton via lazarus pisze: This code says it creates TEST_TABLE, but it doesn't store it in the database. If I click the button once, it apparently creates the table. If I then click it the second time, it gives me an error code that the table exists. If I close

[Lazarus] create table doesn't store

2023-02-09 Thread Larry Dalton via lazarus
Using Lazarus 2.2 ORC1-fpc-e.w.w-win64, Windows 11 Microsoft Access 64 bit procedure TAccess_form.ExcelTestButtonClick(Sender: TObject); var create_string:string; begin ExcelTestQuery.Close; ExcelTestQuery.SQL.Clear; create_string:='CREATE TABLE TEST_TABLE'; ExcelTestQuery.SQL.Append(create_str