Hello!
I have a database on Firebird. There are a table:
CREATE TABLE CONTESTS(
CCID INTEGER NOT NULL,
CONSTRAINTPK_CONTEST_C PRIMARY KEY (CCID),
NAME CHAR(30),
ABOUT BLOB SUB_TYPE 0 SEGMENT SIZE :pSIZE ,
LOGO BLOB SUB_TYPE 0 SEGMENT SIZE :pSIZE );[/code]
I wa
Also, I get exception from MSEIDE 'con: Execute, -invalid BLOB ID' when type of
variables "about" and "img" is integer.
--
All the data continuously generated in your IT infrastructure
contains a definitive record of
On 12/03/2011 05:55 PM, Aton wrote:
> Hello!
> I have a database on Firebird. There are a table:
> CREATE TABLE CONTESTS(
> CCID INTEGER NOT NULL,
> CONSTRAINTPK_CONTEST_C PRIMARY KEY (CCID),
> NAME CHAR(30),
> ABOUT BLOB SUB_TYPE 0 SEGMENT SIZE :pSIZE ,
> LOGO
Martin Schreiber writes:
> Blobs use a special protocol in Firebird, I don't think it is possible
> to write blobs in a simple parametrized SQL statement. Please use a
> tmsesqlquery to fetch and write your data with blobs to from/to Firebird.
>
> Martin
So, I must use something like CreateBlob
On 12/04/2011 09:03 AM, Aton wrote:
> Also, I get exception from MSEIDE 'con: Execute, -invalid BLOB ID' when type
> of
> variables "about" and "img" is integer.
>
This is correct, in blob fields Firebird stores the BLOB ID instead of
the actual data. If you supply a integer value which does n
On 12/04/2011 09:20 AM, Aton wrote:
> Martin Schreiber writes:
>
>> Blobs use a special protocol in Firebird, I don't think it is possible
>> to write blobs in a simple parametrized SQL statement. Please use a
>> tmsesqlquery to fetch and write your data with blobs to from/to Firebird.
>>
>> Mart
On 12/04/2011 09:20 AM, Aton wrote:
> Martin Schreiber writes:
>
>> Blobs use a special protocol in Firebird, I don't think it is possible
>> to write blobs in a simple parametrized SQL statement. Please use a
>> tmsesqlquery to fetch and write your data with blobs to from/to Firebird.
>>
>> Mart
> I don't think it is possible
> to write blobs in a simple parametrized SQL statement.
AFAIK, possible for non-parameterized SQL if blob data are escaped to HEX text.
2011/12/4, Martin Schreiber :
> On 12/04/2011 09:20 AM, Aton wrote:
>> Martin Schreiber writes:
>>
>>> Blobs use a
On 12/04/2011 10:02 AM, IvankoB for-mse wrote:
>> I don't think it is possible
>> to write blobs in a simple parametrized SQL statement.
>
> AFAIK, possible for non-parameterized SQL if blob data are escaped to HEX
> text.
>
In Firebird? Are you sure?
I'll check if it is possible to
Martin Schreiber writes:
>
> On 12/04/2011 09:20 AM, Aton wrote:
> > Martin Schreiber writes:
> >
> >> Blobs use a special protocol in Firebird, I don't think it is possible
> >> to write blobs in a simple parametrized SQL statement. Please use a
> >> tmsesqlquery to fetch and write your data
>> AFAIK, possible for non-parameterized SQL if blob data are escaped to HEX
>> text.
>>
> In Firebird? Are you sure?
Anyway, it's not a solution since bloats data size (already large in
the BLOB case) in times.
--
All th
On 12/04/2011 10:15 AM, Aton wrote:
>
> Ok, and how I should use tmsesqlquery for reading and writing? I found in
> TSQLQuery methods "insertrecquery", "deleterecquery" and others. That's what
> i
> need? I'm newbe in mseide.
>
Set the select statement ("SQL" property = "select * from table1")
> Should working without internet connection be possible? If yes the
> question of secure and safe local storage should be answered first.
>
My collegues say "Yes, it should!". Me still insist on putting comm
channels in order since "Now is the 21-th century!"
> Are you sure there is no crash s
> Martin
Thanks, all became clear!
--
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more
How about an option to draw virtual keyboard (with related chars) at
password entry widget ?
It will greatly protect encrypted RSA keys,..
Sure not in an OS window otherwise it can be intercepted by hacked API.
--
All the
On 12/03/2011 05:55 PM, Aton wrote:
> Hello!
> I have a database on Firebird. There are a table:
> CREATE TABLE CONTESTS(
> CCID INTEGER NOT NULL,
> CONSTRAINTPK_CONTEST_C PRIMARY KEY (CCID),
> NAME CHAR(30),
> ABOUT BLOB SUB_TYPE 0 SEGMENT SIZE :pSIZE ,
> LOGO
On 12/04/2011 03:15 PM, IvankoB for-mse wrote:
> How about an option to draw virtual keyboard (with related chars) at
> password entry widget ?
> It will greatly protect encrypted RSA keys,..
> Sure not in an OS window otherwise it can be intercepted by hacked API.
>
Good idea. Entering the passw
>> How about an option to draw virtual keyboard (with related chars) at
>> password entry widget ?
>> It will greatly protect encrypted RSA keys,..
>> Sure not in an OS window otherwise it can be intercepted by hacked API.
>>
> Good idea. Entering the password by mouse click?
>
Yeath. Possibly wi
> calling OS provided
> ones (designed for disabled people & recovering passwords) is highly
> discouraged.
Because their layouts are predefined and they're present by OS windows
whose drawing/pointer operations can be grabbed by viruses.
2011/12/4, IvankoB for-mse :
>>> How about an option to dr
Hallo IvankoB,
Du schriebst am Sun, 4 Dec 2011 14:38:12 +0500:
> The project is multiplatform & shoulkd run on Ex2..4/NTFS/FAT32. The
> later is known crash-prone.
>
> > As an additional measure frequent automatic backups and automatic
> > recovery could be implemented.
Another (set of) measure
Hallo IvankoB,
Du schriebst am Sun, 4 Dec 2011 19:15:54 +0500:
> How about an option to draw virtual keyboard (with related chars) at
> password entry widget ?
> It will greatly protect encrypted RSA keys,..
> Sure not in an OS window otherwise it can be intercepted by hacked API.
You cannot av
if "someone" has found a way to hijack the grafic system of
your machine
=
Also a network firewall on LINUX-based LAN router can be used to
prevent from accessing virus's remote desktop servers (to view/grab
GUI windows) on infected win-32 machines and sending stolen data from
the
Anyway, either virtual keyboard or password changed each logon with
sending confirmation SMS etc (needs external services) or USB-tokens
(not a cheap solution) or callback (can't be used for DB logon etc).
2011/12/5, IvankoB for-mse :
> if "someone" has found a way to hijack the grafic system of
23 matches
Mail list logo