Re: [sqlite] SQLite3.dll for OS x64
download source fro offixal site in C. then Create c++ project and add sqlite file.. rewrite code under с++. duild with x64 compiler. and Bingo!! all works -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite3-dll-for-OS-x64-tp62292p62317.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite3.dll for OS x64
I download source fro office site. rebild it to the x64. But sqlite3.dll not work. If many code rewrite for work for x64 pleace say where i can download. or say where i can read manual for recognize. -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite3-dll-for-OS-x64-tp62292p62302.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite3.dll for OS x64
In the offical site i have not found dll for x64 OS. Where can I download it? -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite3-dll-for-OS-x64-tp62292.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] out of sequence error 2
How wait for finish query? while(q1.step()); // or q1.fetch() this function i not find CppSQLite3Query q2= db.execQuery(...); otherstring = db.execQuery(two); // out of sequence error q2.finalize(); -- View this message in context: http://old.nabble.com/out-of-sequence-error-2-tp32377689p32377689.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] out of sequence error 2
i think. problemm from parallel access not i try create mutex in main
project, than sent mutexHandle to my dll and
dw = WaitForSingleObject(hMutex, 5000L) ;
Messagebox(0,Lmessage,Lbox,0); // this messaege(0,L,L,0);
if (dw == WAIT_OBJECT_0)
{
CppSQLite3Query q = base.execQuery( tmp );
result = utf8_to_unicode(q.getStringField( 0 ));
//MessageBoxW(0,result,L,0);
q.finalize();
}
--
View this message in context:
http://old.nabble.com/out-of-sequence-error-2-tp32377689p32378483.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] error:library routine out of sequence
when i Offen use this code i see error library routine out of sequence.I
understand that swears on a second appeal to the already open as BD.No then
make additional requests to fetch?
wchar_t * IconDB::SQLGetConfigValue(char *Key)
{
CString s;
wchar_t * result;
char tmp[255];
CppSQLite3Query q;
try
{
strcpy(tmp,SELECT Value FROM Config WHERE Key = \);
strcat(tmp, Key);
strcat(tmp, \);
CppSQLite3Query q = base.execQuery( tmp ); // Error
result = utf8_to_unicode(q.getStringField( 0 ));
q.finalize();
}
catch(char *str){ MessageBoxA(0,str,SQLGetConfigValue,0); }
return result;
}
--
View this message in context:
http://old.nabble.com/error%3Alibrary-routine-out-of-sequence-tp32365078p32365078.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error:library routine out of sequence
This line most finalizate
q.finalize();
or not?
IO use in the COM object when i open folder I do it somethink with Database
STDMETHODIMP CMyOverlayIcon2::IsMemberOf(LPCWSTR pwszPath, DWORD dwAttrib)
{
// use only select query
(!wcscmp(db.SQLGetConfigValue(Active) ...
}
--
View this message in context:
http://old.nabble.com/error%3Alibrary-routine-out-of-sequence-tp32365078p32365913.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error:library routine out of sequence
Ok I understand. And what i most do it? -- View this message in context: http://old.nabble.com/error%3Alibrary-routine-out-of-sequence-tp32365078p32367279.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite + unicode
Thanks i change 1251 to CP_UTF8 All work :jumping: -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32301685.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite + unicode
For and '' i know thanks, and why you write ? i want write arabic symbul مثالمثالمثالمثال -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32300446.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite + unicode
I try this function. Do you have Visual Studio. i show you my example.
NOCaut wrote:
char * unicode_to_1251(wchar_t *unicode_string)
{
int err;
char * res;
int res_len = WideCharToMultiByte(
1251, // Code page
0, // Default replacement
of illegal chars
unicode_string, // Multibyte characters string
-1, // Number of unicode
chars is not known
NULL, // No buffer yet, allocate it
later
0, // No buffer
NULL, // Use system default
NULL// We are not interested
whether the default char was used
);
if (res_len == 0)
{
printf(Failed to obtain required cp1251 string length\n);
return NULL;
}
res = (char*)calloc(sizeof(char), res_len);
if (res == NULL)
{
printf(Failed to allocate cp1251 string\n);
return NULL;
}
err = WideCharToMultiByte(
1251, // Code page
0, // Default replacement
of illegal chars
unicode_string, // Multibyte characters string
-1, // Number of unicode
chars is not known
res,// Output buffer
res_len,// buffer size
NULL, // Use system default
NULL// We are not interested
whether the default char was used
);
if (err == 0)
{
printf(Failed to convert from unicode\n);
free(res);
return NULL;
}
return res;
}
--
View this message in context:
http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32301058.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite + unicode
this is my example spellings on the VS2008 http://www.4shared.com/file/RDzSVPZq/SQLite_example.html -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32301433.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite + unicode
Say my some wrapper for i can make this query: Select Value from Config Where Key = \بوبوبو\ Thanks. -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32296232.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite + unicode
I now how work with sqlite guys my problem: in const char * and i wont wchar_t*. becouse wchar_t* - unicode type understand int sqlite3_exec( sqlite3*, /* An open database */ const char *sql, /* SQL to be executed */ sqlite3_callback, /* Callback function */ void *, /* 1st argument to callback function */ char **errmsg /* Error msg written here */ ); sqlite3 *db; char *zErrMsg = 0; int rc; rc = sqlite3_open(c:\\test.db, db); rc = sqlite3_exec(db, Select * from table , callback, 0, zErrMsg); this code return char I want use wchar_t* for read unicode. Thanks! -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32240215.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite + unicode
You think i most 1 -convert to UTF-8 2 -read un the const char * 3 - convert to anscii i right understand you? -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32241427.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite + unicode
I want use but sqlity3.h NOT have this function. and i create this post for you help me use this function -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32241783.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite + unicode
please kill me %-| -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32242440.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite + unicode
It`s so hard for me. I'll be very grateful :jumping: -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32243061.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite + unicode
Where i can find c++ unicode unit for work with SQLite database? Thanks. -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32235242.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite + unicode
Sorry for my bad english)) I want find source code for work with sqlite.. -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32235334.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite + unicode
in the other forum say: You can get the SQLite source code and compile it directly with C++ Builder (2010 and XE tested). Come to home and see -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32235384.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite + unicode
I work in VS2008 c++ i create data base my.db and wont use U N I C O D E function from this DLL i find class or unit for connect to my base from VS2008 http://sqlite.org/download.html - this link help me? you understand me? -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32235242p32235681.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
