TADOQuery adding fields..

From: Trevor <trevorjm@xxxxxxxxxxxxxxx>
Date: Thu, 30 Jun 2005 01:51:11 +1000

Hi;

  	I'm having one of those nights.
	I've done an update to a table adding 2 new fields.
	I now want the program to recognise that these new fields
	exist. Perhaps a little more info...

	Version 1 of the program only has 8 fileds in one of the
	tables. These 8 fileds are listed in the TADOQuery Fields
	list box. (double click on the TADOQuery Icon)

	In sending out Version 2 of the program, I firstly check
	what version the user has, if version 1, then update the
	table adding the 2 new fileds. The Program now tells the
	user you are using version 2, and off we go to the normal
	startup screen.

	I now want the Fields list box to also show that the 2 new
	fields are there. The data in one of these fields is to be
	shown on the start up screen, and the display reads the data
	as such..

	Label5.Caption := 'Your Name ' + Sys.FieldValues['Ver'];

	where Sys.FieldValues is TADOQuery type
	and Ver is the new field..

	So for the above to work I need to add the two new field
	names to the TADOQuery list box.

Thanks.
Trevor..
.

Prev by Date: Re: Languages with Install Shield Express Borland Limited Edition 3.5 SP4
Next by Date: ($DEFINE) seems to stay within the one .pas file
Previous by thread: DELPHI/ OO/ CONTRACT TO HIRE/ ATL
Next by thread: ($DEFINE) seems to stay within the one .pas file
Index(es):
- Date
- Thread

Relevant Pages

TADOQuery fields list box.
... I now want the program to recognise that these new fields ... These 8 fileds are listed in the TADOQuery Fields list box. ... and Ver is the new field.. ...
(comp.lang.pascal.delphi.databases)
Re: TADOQuery fields list box.
... but the same thing happens with TQuery. ... if AddFields doesn't show the two new fields: ... These 8 fileds are listed in the TADOQuery Fields ...
(comp.lang.pascal.delphi.databases)
Re: TADOQuery fields list box.
... This should get the field info from the table, ... the compiler to regenerate all the info it uses. ... These 8 fileds are listed in the TADOQuery Fields list box. ...
(comp.lang.pascal.delphi.databases)