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
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
> 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 i
To create a table:
-
int iTablesCount = liststTableNames.Count();
try {
string stOpenConn = new FbConnectionStringBuilder {
Database = stPathFilename,
UserID = stUserID,
Password = stPassword,
ServerType = F
