Devart Forums

inageib

Wow many thanks frickler
I can connect now !!

inageib

I encrypted with sqlite maestro . how I can encrypt with unidac ?

inageib

When I specify "leAES128" for encryption algrithms I get "not a database file" and if I used "leDefault" I get

---------------------------
Error
---------------------------
The EncryptionKey property must be empty when no encryption algorithm specified.
---------------------------
OK Details >>
---------------------------

inageib

Hi

I encrypt my sqlite database using Delphi sample application to encrypted the file but now I am trying to open the database using unidac uniconnect1 and I set the encryption key in the option tab but I get this error when I try to connect:

Code: Select all

---------------------------
Error
---------------------------
SQLite DLL that you are using does not support SQLite database encryption. 
Please download a new DLL or recompile the existing one with encryption support. .
---------------------------
OK   Details >>   
---------------------------

How to fix this ?

inageib

@ZEuS

I dont understand you said to set required to to true but in the code you set it to false !! what is the correct sequence ?

inageib

@MaximG

Did you able to test this ? I really can not find a solution

inageib

thank but I already set defaultvalues = true

inageib

thanks but this is can not be the reason. I use SQLite maestro and when I create a field it set it automatically as not null without any option to make it nullable. Beside inside sqlite maestro I can insert new records without getting the patient_id field must have a value so it got to be something I need to do from Delphi.

see picture
https://www.photobox.co.uk/my/photo/ful ... 0977236181

inageib

I created a new demo with unencrypted db and a test button to insert new record. I sent it by the contact form. Please advise

inageib

Any replay please.

inageib

I already did that here is the SQL

Code: Select all

CREATE TABLE patients (
  ptient_id        integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  patient_name     varchar(300) NOT NULL,
  patient_age      smallint,
  patient_address  varchar(300),
  patient_phone    varchar(50),
  patient_weight   float(50),
  patient_notes    text,
  patient_mstatus  smallint DEFAULT 0
);

the encryption key is in a txt file with the database

please advise what to do

inageib

I sent a demo please check it.

thanks

inageib

many thanks for your kinds

inageib

Can you please advise for a documentation on how to connect to android firebird and how to deploy firebird for android ?

inageib

I write same code but still get error that id need a value so there must be a property to change. I use TUNITable

Code: Select all

object tblPatients: TUniTable
    TableName = 'patients'
    Connection = UniConnection1
    Transaction = UniTransaction1
    UpdateTransaction = UniTransaction1
    KeyFields = 'ptient_id'
    Constraints = <>
    IndexFieldNames = 'ptient_id'
    Options.DefaultValues = True
    Left = 144
    Top = 96
  end

Devart Forums

Search found 184 matches

Re: SQLite encryption

Re: SQLite encryption

Re: SQLite encryption

SQLite encryption

Re: How to make auto increament key to trigger ?

Re: How to make auto increament key to trigger ?

Re: How to make auto increament key to trigger ?

Re: How to make auto increament key to trigger ?

Re: How to make auto increament key to trigger ?

Re: How to make auto increament key to trigger ?

Re: How to make auto increament key to trigger ?

Re: How to make auto increament key to trigger ?

Re: IBDAC and Firebird for Android ?

Re: IBDAC and Firebird for Android ?

Re: How to make auto increament key to trigger ?