Field format in Queries

[wichtel]

Hello,

Is it possible to define field formats of Update-Queries?
In particulary, how can I define a field in the querie as decimal (28,10)?

Thanks for your help
Tom

 

[KenReay]

Hi

In an update query, you cannot change the definition of the field type, all you can do it to change (update), the contents of a column (field), if you want to upadte the table structure you need to look at the SQL DDL commands (DDL - (D)ata (D)efinition (L)anguage)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[TheAceMan1]

How are ya wichtel . . . . .

Yes! . . . just call-up the properties window. You'll find [blue]Format[/blue] there.

You only need to format in the UpDate Query [blue]if it isn't similar or the same as the format in the table[/blue]. The Update Query will do its best to [blue]coerce to that format.[/blue]

Be careful here, its possible to raise a [purple]Data Type MisMatch Error![/purple]

See Ya! . . . . . .