SQL query help

mb1824

Hi,

I am trying to write a statement like:

Select * From ABC

However, when I test the query, I get an error:

Field "XYZ" is 0 length.

Is there a way to select all fields except "XYZ" without manually selecting them all using the visual query builder?

Claje

Hi,

Assuming that you don't get new fields in the table that you want to include without changing the query, there is a way to do this in the Visual Query builder.

If you bring your table into the Visual Query Builder, you can right click on it and choose the option "Check All".  Then you can simply uncheck the field "XYZ" that you don't want to include.  I'd also recommend deselecting the "*" option when you are doing this.