OLE automation

[Guest_imported]

Hello

I want to use OLE automation to modify a database.

I use WINDEV5.5 to do this modification.

I can open access and the database with the OpenCurrentdatabase function and I can open the table that i want to modify in design with the OpenTable function

But i don't know how to modify the AllowZeroLength property of a text field.

Please Help me

 

[hennep]

when you have opened the database, search for the table in the tabledefs collection then in this tabledef search for the field in the fields collection

db is the database you've just opened.

for each td in db.tabledefs
if td.name = "TheTableYouAreLookingFor" then
for each fd in td.fields
if fd.name = "TheFieldYouAreLokkingFor" then
fd.AllowZeroLength = true
next fd
endif
next td