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 · Accepted solution]

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.

[ZacharyM]

+1 to @Claje's post above - you can absolutely do this as described - and definitely do make sure you unchecked the * as well.

[mb1824]

@Claje

Awesome, thank you so much!