Re: SQL Insert - Solved

Author: Gérard Lochon

Posted: 2014-01-03 at 07:44:42

----- Original Message -----

From: "Jeff Johnson" <jeff@san-dc.com>

To: <profoxtech@leafe.com>

Sent: Friday, January 03, 2014 2:29 PM

Subject: Re: SQL Insert - Solved

> Sorry to bother you guys with this one. I should have known. I expected

> that records inserted in sequence would be queried in the same sequence.

> I counted the records this morning and they are all there. Just out of

> sequence.

>

> I did learn a lot by the discussion, though. Especially Frank's improved

> way of building the query strings.

>

> Thanks all.

>

> Jeff

Glad you've find the trick.

Remember that conceptually, in a relational database,

n-uplets (or records) are NOT known by their position ...

that's only a reminder of old -very- procedural way of thinking !

Gérard.

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/B82A7BA3944E44EDB8267D15C35E1E74@MuriellePC

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2014 Gérard Lochon