1) I think it would be
string stOpenConn = new FbConnectionStringBuilder {
Database = stPathFilename,
UserID = stUserID,
Password = stPassword,
ServerType = FbServerType.Embedded,
ClientLibrary = stCLIENT_LIBRARY
}.ToString();
using (FbConnection fbConn = new FbConnection(stOpenConn)) {
try {
fbConn.Open();
On Thu, Mar 23, 2017 at 8:30 AM, Clyde Eisenbeis <[email protected]> wrote:
> 1) It's not obvious to me where to put the 'using' with 'try'. Could
> you provide an example using the code in my first email?
>
> 2) Is this what you recommend?
>
> where stSql = "CREATE TABLE TableOrg ( fstPriority VARCHAR(10),
> fstInfo VARCHAR(x) CHARACTER SET UNICODE_FSS, fiKeyID INTEGER PRIMARY
> KEY )".
>
> What do I use for 'x'? This should be variable.
>
> 3) BLOB SUB_TYPE TEXT is non-Unicode. The field 'fstInfo' needs to
> handle German.
>
> On Thu, Mar 23, 2017 at 2:11 AM, Jiří Činčura <[email protected]> wrote:
>>> 1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ...
>>> followed by one fbTransaction.Commit()?
>>
>> Yes. Also use `using` block for disposable resource.
>>
>>> 2) I want to be able to handle German vowels, such as umlauts, for
>>> fstInfo. I don't think VARCHAR is the correct choice as it is
>>> non-unicode.
>>
>> You can use CHARACTER SET clause. Best is probably to use UTF8.
>>
>>> 3) I also want variable lengths, without a max, for fstInfo. What do
>>> I use in place of the "100"?
>>
>> Then you have to use BLOB SUB_TYPE TEXT.
>>
>> --
>> Mgr. Jiří Činčura
>> https://www.tabsoverspaces.com/
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> _______________________________________________
>> Firebird-net-provider mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
