Replies 4 replies
Subscribers 585 subscribers
Views 487 views
Users 0 members are here

Options

Related

Write Alarm to SQL database

Александр over 5 years ago

I want to write an alarms to the database. When creating the device format, I need the "Desc" field.

{date,10}{time,8}{category}{almcomment,80}{fullname,80}{userlocation,15}{state,9}{tag,80}{type,48}{desc,128}

But this word is the key to the DBMS. And the recording is not made. How to get out of this situation?

Parents

Anton over 5 years ago

HELP says us: Keywords such as "DATE", "TIME", and "DESC" cannot be used as field names by some database systems. To use fields with these names, you need to append underscores to the names (for example, "TIME_", "DATE_", "DESC_").

Cicode Programming Reference > Cicode Function Categories > SQL Functions > SQLFieldInfo
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Anton over 5 years ago

HELP says us: Keywords such as "DATE", "TIME", and "DESC" cannot be used as field names by some database systems. To use fields with these names, you need to append underscores to the names (for example, "TIME_", "DATE_", "DESC_").

Cicode Programming Reference > Cicode Function Categories > SQL Functions > SQLFieldInfo
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

No Data