Radicore Forum: Application Development » How can I achieve retrieving data from different tables and marking them as printed?

Home » RADICORE development » Application Development » How can I achieve retrieving data from different tables and marking them as printed?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: How can I achieve retrieving data from different tables and marking them as printed? [message #1823 is a reply to message #1822]

Tue, 11 November 2008 11:34

AJM
Messages: 2370
Registered: April 2006
Location: Surrey, UK

Senior Member

It is not possible to select a record from the database, then update it to say that it has been processed, if it does not have a primary key.

If you build a database table which does not have a primary key then you are asking for trouble.

If you are trying to merge data from several tables and treat them as if they come from a single table then this is only possible if those tables have identical structures. This is one of the limitations of a UNION in SQL. If they do not have identical structures then you must use alias names in the select list to force the list of column names to be identical.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		How can I achieve retrieving data from different tables and marking them as printed? By: bonzo_bcn on Tue, 11 November 2008 06:50
		Re: How can I achieve retrieving data from different tables and marking them as printed? By: AJM on Tue, 11 November 2008 07:41
		Re: How can I achieve retrieving data from different tables and marking them as printed? By: bonzo_bcn on Tue, 11 November 2008 10:39
		Re: How can I achieve retrieving data from different tables and marking them as printed? By: AJM on Tue, 11 November 2008 10:52
		Re: How can I achieve retrieving data from different tables and marking them as printed? By: bonzo_bcn on Tue, 11 November 2008 11:04
		Re: How can I achieve retrieving data from different tables and marking them as printed? By: AJM on Tue, 11 November 2008 11:09
		Re: How can I achieve retrieving data from different tables and marking them as printed? By: bonzo_bcn on Tue, 11 November 2008 11:21
		Re: How can I achieve retrieving data from different tables and marking them as printed? By: AJM on Tue, 11 November 2008 11:34
		Re: How can I achieve retrieving data from different tables and marking them as printed? By: bonzo_bcn on Wed, 12 November 2008 15:27
		Re: How can I achieve retrieving data from different tables and marking them as printed? By: bonzo_bcn on Wed, 12 November 2008 16:07
		Re: How can I achieve retrieving data from different tables and marking them as printed? By: AJM on Wed, 12 November 2008 17:16

Previous Topic:	$where clause problem with list1 and read
Next Topic:	Performance problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Nov 27 03:41:13 EST 2024

Total time taken to generate the page: 0.01638 seconds