Search found 18 matches

by alexhaifa
Wed 05 Jan 2022 13:40
Forum: dbExpress driver for SQL Server
Topic: problem using two dataset linked through parameters.
Replies: 4
Views: 25870

Re: problem using two dataset linked through parameters.

I've just sent an example with the problem.
Please, fix that as soon as possible, that is impacting many applications of mine.
Regards
Alexandre
by alexhaifa
Thu 15 Oct 2020 19:10
Forum: dbExpress driver for SQL Server
Topic: Unknown driver: DevartSQLServer. Delphi 10.4
Replies: 1
Views: 11870

Unknown driver: DevartSQLServer. Delphi 10.4

Hello Guys,

In project time I can log in my DB and I don't have any problem.
But when I run the application, I get this message:

[ Unknown driver: DevartSQLServer. ]

My connection configuration are:

Code: Select all

BlobSize=-1
HostName=192.168.2.7,1438
DataBase=Hermesqualidade1
DriverName=DevartSQLServer
User_Name=sa
Password=z3us
LongStrings=True
EnableBCD=True
FetchAll=True

Where my application.exe is in, I have the dbexpsda41.dll

Regards
by alexhaifa
Wed 06 Jul 2016 23:54
Forum: VirtualDAC
Topic: Sql comands and VirtualTable
Replies: 3
Views: 5421

Re: Sql comands and VirtualTable

this implament was made?

Thanks
by alexhaifa
Wed 06 Jul 2016 23:50
Forum: InterBase Data Access Components
Topic: Encrypting field data in a pre-existing table
Replies: 5
Views: 2794

Re: Encrypting field data in a pre-existing table

Hello,

Could you give me the example how to use the :

IBCConnection1.EncryptTable('CADPAL', ?????????, 'PALAVRA_EST');

I didn't find any help on this functionaly

Thanks
by alexhaifa
Tue 05 May 2015 18:31
Forum: InterBase Data Access Components
Topic: How to get the recordcount?
Replies: 3
Views: 1680

Re: How to get the recordcount?

Thanks very much
by alexhaifa
Tue 05 May 2015 14:56
Forum: InterBase Data Access Components
Topic: How to get the recordcount?
Replies: 3
Views: 1680

How to get the recordcount?

Hello,

When I use the code this way:

IBCquery.RecordCount

It always return me the 25 registers.

How to get all the recordCount correctly?

Thanks
by alexhaifa
Tue 10 Mar 2015 16:47
Forum: InterBase Data Access Components
Topic: How to export a query to another database?
Replies: 1
Views: 1266

How to export a query to another database?

Hello,

How can I export a query from my IBCQuery to access database, excel or csv?
is there any component that I can do that? Today I use Basic IBDAC components.

thanks
Alexandre
by alexhaifa
Tue 10 Mar 2015 16:42
Forum: InterBase Data Access Components
Topic: how to work around with lack of security?
Replies: 1
Views: 1258

how to work around with lack of security?

Hello,

Something very bad is in firebird, the user and password to access the database file is kept into the server and not into the data file (.FDB) - We haven't had this option so far, unfortunately.

I developed a dictionary system that is going to be sold to many clients, but I'd like that
anyone could copy my database and open it into its firebird installed in any computer, nowadays it is possible only using the default user and password :(

I'd like to protect my data against any possibility to be access without my system.

How to work around with this? is there any way with any component?

thanks
Alexandre
by alexhaifa
Tue 03 Mar 2015 17:58
Forum: VirtualDAC
Topic: Sql comands and VirtualTable
Replies: 3
Views: 5421

Sql comands and VirtualTable

Is it possible to use query with virtualTable?

As I understood, virtualTable is a memory table repository. I'd like to know if other components can be linked to it, such is, IBCquery.

thanks
Alex
by alexhaifa
Tue 03 Mar 2015 17:33
Forum: InterBase Data Access Components
Topic: Encrypted table and SQL comands
Replies: 1
Views: 1193

Encrypted table and SQL comands

Hello

Having all my table encrypted, I'd like to know if it is possible to use the SQL comands normally? Like this:

SELECT * FROM TABLE
WHERE NAMEPROD LIKE '%XYZ%'

Thanks
Alexandre
by alexhaifa
Tue 03 Mar 2015 17:29
Forum: InterBase Data Access Components
Topic: Encrypting field data in a pre-existing table
Replies: 5
Views: 2794

Re: Encrypting field data in a pre-existing table

Hello,

this function was implamented ? Is it possible now to encrypting a pre existing table?

thanks
Alex
by alexhaifa
Mon 22 Sep 2014 13:28
Forum: InterBase Data Access Components
Topic: RecordCount, geting only partial
Replies: 1
Views: 1722

RecordCount, geting only partial

Hello,

when I open my IBCQuery I need to get all recordcount that my Query got, but through this
way

IBCQuery.RecordCount

It returns me only the partial.

How can I get all the records count from my query?

Thanks
Alex
by alexhaifa
Mon 30 Jun 2014 01:59
Forum: InterBase Data Access Components
Topic: Help with clientdataset and IBCquery
Replies: 1
Views: 1440

Help with clientdataset and IBCquery

Hello,

Maybe you can help me with to understand the better way to work with these components together.

I am really having problens to configure or to go right in the configuration to work with IBCQuery + DataProvider + ClientDataset

I'd like to know what is the correct way to configure ClientDataset + Provider + IBCQuery

I have a small table with 5 fields, the first field is a primary key. I tried many things, sometimes with some configuration I have an error where the system can't find the key field, other it can update but didn't insert any new record. I tried many things and I didn't have any success.

Could you give me a small example with the steps to make this work fine?

thanks
Alexandre
by alexhaifa
Mon 02 Jun 2014 19:48
Forum: InterBase Data Access Components
Topic: TIBQuery and Sort
Replies: 4
Views: 2039

Re: TIBQuery and Sort

Hello,

Don't worry

I have found the solution :))

DataSet1.IndexFieldNames := 'LastName ASC CIS; DateDue DESC';

http://www.devart.com/ibdac/docs/index. ... tions).htm
by alexhaifa
Mon 02 Jun 2014 19:44
Forum: InterBase Data Access Components
Topic: IBQuery and Locate sensitive case
Replies: 3
Views: 1406

Re: IBQuery and Locate sensitive case

Thanks very much

You're right!! I had forgotten about this :))