Source language: Translate to:

Something to smile... - SQL-coding for advanced developer

Questions or information that don't quite fit anywhere else

Moderator: Neosoft Support

Something to smile... - SQL-coding for advanced developer

Postby cipolla » Fri Jan 30, 2004 11:03 am

Just to close a hard workday...

SQL-coding for advanced developer
Today: The save query for a canteen visit

SELECT cutlet, frenshfries, mayonnaise
FROM tblCanteenqueryquery
WHERE (price_cutlet + price_frenshfries + price_mayonnaise) < (income/100)
AND Cutlet_date_of_expiry > GETDATE()
AND Cutlet_BSE = FALSE
AND Frensh_fries_fried_grease = GETDATE()
AND Mayonnaise_consistency NOT '%salmonellae_biotope%'
AND Cook_alcoholemia <= 0
AND Till_girl LIKE "90,60,90"

IF "[query]" "=" "True"
 SetVar "[ToDo]" "Enjoy your meal!"
Else
 SetVar "[ToDo]" "Get a hamburger!"
EndIF

So long
Klaus
cipolla
 

Something to smile...

Postby HPW » Fri Jan 30, 2004 11:15 am

Have you test it on SQLite?

:-))
HPW
 


Return to Misc. Questions and Information

Who is online

Users browsing this forum: No registered users and 2 guests

cron