Lynn,

this will not work.. maybe if you include DISTINCT. As to now, select in the IN clause will return two rows with exactly the same value... supposing there are two or more...

I don't know anything about limitations of Mobile SQL, but to hold to the style with which you started, it would be better to write it this way:

SELECT col1, col2,...

That's precisely what I was trying to put across - it depends on what you need. I probably never needed anything for last 24 hours

No, it wouldn't. That is, it may be easier, but it will not work properly.

GETDATE() returns for example 2006-10-17 16:34:27. DATEADD/DATEDIFF are there mainly to cut off the time portion, and I...

Sergiy,

regarding payments, almost anything can happen. I know that sometimes the cash attendant in a shop enters wrong amount when performing the card payment, and client pays the difference in cash......

"Just semantics but how can yesterday be from last month?"

Well, I suppose it was meant as "if today is the first of a month, yesterday is the last day from previous...

hi coorgi,

you have edited your message before I managed to reply ... so now my reply seemed a bit out of place

What I mean is this...

There are two different things: One is how the data are stored in the database, another is how they are displayed to the user. ID column values don't need...

Thanks, now I understand better what you meant... If you want to have just one table of types (containing type code, type description and "type of the type", i.e. Table_1),...

You can find some good ideas regarding usage of parameter lists (including the possibility to search for all if parameter is not supplied) here:

http://www.sommarskog.se/dyn-search.html

http://www.sommarskog.se/arrays-in-sql.html

As I understood the post, Greg only wants to create FK "for information", without any functionality :

"This foreign key will be disabled and only be used to easily find relationships in the...

Hi,

What precisely do you need?

Are you looking for a database design, or is the database already in place and you only need to create a query that will propose the...

Thanks for the link, David. It is now clear that it isn't bug, but normal behaviour. I didn't think about it this way before - I supposed that the (select...

That's really strange... I didn't know about this behaviour.

I tested this on a normal (user) table, and results are the same, so it isn't some idiosyncrasy of system tables.

If you...

Hi Eddy,

since you didn't post table definitions and their relationships, I can only guess what columns are in table etshortagetemp and how to use them to update the correct rows....