Also the eye wants its part

Posted by dragon on Friday, 30 September 2011

Warning: this article has been modified on 7 February 2007.
You will have noticed that the fields of database Firebird 1.5.3 must have the form my_field or MYField and without accents or apex, or space as in "My Field".
We can instead give to the field the form which we want: that is "My Field" or "Citta'" or other type, if we set for the database, as character set, charset UTF8, and we can make it if we use an other free software of management for Firebird called FlameRobin 0.7.6 from SourgeForge.net here. Pay attention, in the query in VB.net, to the way as the fields of which has been spoken over, are written in a SQL statement: in order to make an instruction update example , the instruction must be written therefore: “update table set ""MY FIELD"" = 'Roma'", which is the field which must be all in capital, and this works even if the last letters of the field are accented or with apostrophe. FlameRobin is useful also because it gives, more of the other software, one information detailed on the errors in the query. It remains plain which, for the other uses are convenient the other software of management which I have indicated before.

{ 0 comments... read them below or add one }

Post a Comment