Check if field exists in table

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
shsit
Posts: 21
Joined: Thu 05 Oct 2006 11:41

Check if field exists in table

Post by shsit » Wed 02 Sep 2009 09:47

Hello,

I simply want to check if a field exists in a specific table.
Thx,
greets ben

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 02 Sep 2009 11:28

To solve the problem you can use the FindField method, like this:

Code: Select all

If MSQuery.FindField(FieldName)  nil then
...

Post Reply