There must be a way to replicate the dBase/Clipper/Xbase function
AppendFrom in DBisam ?

I'am  really getting so forgetful as the weeks go by OldTimers
is kicking in fast

All I need to do is allow users of my lottery app to update their
desktop application from my server going by the last record
date on local machine then download just the records later than
the last date.
Simple right 10 years ago I would never have asked this question
as its so simple ;-(
Rita The Old Hag

Rita


Assuming you're using SQL something like

INSERT INTO table1 SELECT * FROM table2 WHERE date > table1.date

Roy Lambert

"Roy Lambert"  wrote in message
news:4FF2C431-1D63-4E21-918F-8DFEED4FD78C@news.elevatesoft.com...

Rita


Assuming you're using SQL something like

INSERT INTO table1 SELECT * FROM table2 WHERE date > table1.date

#########################################################################################

Thanks Roy I will go the SQL

rITA

"Roy Lambert"  wrote in message
news:4FF2C431-1D63-4E21-918F-8DFEED4FD78C@news.elevatesoft.com...

Rita


Assuming you're using SQL something like

INSERT INTO table1 SELECT * FROM table2 WHERE date > table1.date

Roy Lambert
##########################################################################################

Sadly that didnt work

INSERT INTO "newlotto"
SELECT * FROM "LOTTO"
WHERE date > newlotto.date

Tried it in DBSys 1st and clicked prepare it complained
about the > newlotto.date
so I tried

INSERT INTO "newlotto"
SELECT * FROM "LOTTO"
WHERE lotto.date > date

That did not complain but nothing happened no
records where copied.
so I tried

INSERT INTO newlotto
SELECT * FROM LOTTO
WHERE date > date

That didnt work either.
So I will have a re-think on sql

Thanks Rita

Rita



>INSERT INTO "newlotto"
>SELECT * FROM "LOTTO"
>WHERE lotto.date > date

What are you using as date?

DBIASM doesn't do subselects so you'll have to do a separate query to get the newest date from newlotto and then create the sql feeding that date in.

Roy Lambert [Team Elevate]