Loading only Field Names with no data

[#1]

Hi Everyone,

How are you all?

Can someone please tell me how do I load only the fieldnames in a table from a resident table.

I need no data. All I need are the fieldnames(Names allocated in the resident table).

Thanks

[gussfish]

Hi,

there are a couple of helpful functions you'll find in the Table

Functions section of the Reference Manual:

*

FieldName(n,'TableName') - gives you the name of the (n)th field

in your table.

*

NoOfFields('TableName') - gives you the number of fields in your

table

So, you should be able to use these together to load-in the names of all

your table's fields.

Angus.

[perumal_41 · Accepted solution]

Hi,

Try Below Script  helpful   for U

Load * Resident tablename  where 1=2;

try this script.

Regards,

Perumal.A

[#4]

The where clause

Where RecNo() = 0;

also worked to load only tables and fields with no data and returned this

If you need to work with the table names and field names in QV objects (i.e. list boxes) then use $Table and $Field system fields.

In this example I counted number of unique values in each field.

Cheers

P

[#5]

Thanks so much. That was the answer I was looking for.

Regards.

[#6]

Thanks Angus, so much. You answer was really helpful.

Regards.

[#7]

Thanks Pavol fpr your prompt response. You suggestion worked for me.

Regards.