ADE 2002 excution problems

[BJ Freeman]

I have and ADE that calls a Stored procedure, in an interface SQL(VER 7) DB.
This procedure then calls the real procedure in another DB on the same
server.
This ADE works fine in ADE 2000, but ADE 2002 the data is returned. The
recordset is not in the same order as in the one called from ADE 2000.

I know have two clients that show the same behavior.

Any Ideas?

 

[Sylvain Lafontaine]

If the order is important, than you must define a sorting order somewhere,
preferably inside the last stored procedure or in the property of the form.

If you have defined a sorting order in a stored procedure and this one get
called by another procedure, there is absolutely no garantie that the order
will be keep (or even done in the first place) in the second procedure; even
if this last one doesn't add, modify or remove any record. When you create
a new stored procedure, technically you create also a new recordset and it
will have no sorting order if you doesn't have set one.

This is standard SQL procedure.

S. L.

 

[BJ Freeman]

Thanks for the reply.
What gets me, is this works with ADE 2000, flawlessly. Never do I have this
problem.
only when the Same ADE is run under access XP does this show up.