Stack Overflow
Stack Overflow

Questions tagged [unidac]

UniDAC, short for Universal Data Access Components, is a library of nonvisual cross-database data access components for Delphi, Delphi for .NET, C++Builder, and Lazarus (Free Pascal).

Resources:

  • Devart's UniDAC section on its official website.
79 questions
0
votes
1 answer

How to insert several lines batch SQL? { UNIDAC/FIREBIRD]

how insert multiple lines SQL/batch in UNIDAC equal to FIREDAC? Firedac example: FDQuery.ParamByName ('NAME') AsStrings [0] = 'MARIA'; FDQuery.ParamByName ('NAME') AsStrings [1]: = 'JOHN'; FDQuery.ParamByName ('NAME') AsStrings [2]: =…
Warquia
  • 19
  • 5
0
votes
1 answer

Delphi : change uniconnection settings

Is there any way to change a uniconnection settings already created in a data-module and connected to a database I just want it to connect to another database : dmprefrences.AC.disconnect; dmprefrences.AC.Server := 'localhost'…
Jeanette Daher
  • 11
  • 1
  • 1
0
votes
1 answer

Migrate From DevArt UniDac To FireDac

I've been using UniDac for 2 years now and it was the best solution for me, but because it doesn't support Asynch query's i have to move on to FireDac is there any quick migration wizard or something that i can use because i have around 200+…
AirWolf
  • 597
  • 7
  • 27
0
votes
1 answer

Memory leaking inside a big cycle

I have a small procedure to retrieve some text from a database. This function is called several thousand times in a cycle. procedure TMainForm.RetrieveKnowledgeText(const knowledge_id : Integer; var…
Miguel E
  • 1,316
  • 2
  • 17
  • 39
0
votes
2 answers

RecordCount with UniDAC Dataset component

I'm using the TUniQuery component from UniDAC. I'd like to show how many records I have, so I've put the following code to show in a Status Bar: procedure TForm1.unyQuery1AfterFetch(DataSet: TCustomDADataSet); begin StatusBar1.Panels[1].Text :=…
Daniel Grillo
  • 2,368
  • 4
  • 37
  • 62
0
votes
2 answers

Unidac (delphi) macro issue

I have query: select ¯o1 from table1 where ¯o2 delphi code: macrobyname('macro1').value := 'field1 as test,field2'; macrobyname('macro2').value := 'test=1'; i got an error like this: Unknown column test in where clouse question…
amir nouri
  • 9
  • 5
0
votes
1 answer

Delphi Unicode string mismatch

I have a Delphi 7 app using Paradox database via BDE, that I have converted to Delphi XE3 and Firebird. There is a string field in the Paradox database containing an encrypted string that is supposedly used for licensing of the software. The problem…
Steve F
  • 1,527
  • 1
  • 29
  • 55
0
votes
1 answer

How to change values of a mysql database via dbgrid?

Hey guys good morning, i got a DBGrid and the UniDac components. I a use a popupmenu and select a row. I fill via the onclick event from the popupmenu a new form with my data in my TEdit. Now the problem is, that i want to edit my data which i…
Hidden
  • 3,598
  • 4
  • 34
  • 57
0
votes
2 answers

Class TLargeintField not found

I'm using C++ Builder 2009. I've been doing some international work on one of my projects. I've upgraded my query components to UniQuery components and all of my db connections to UniDAC. Now when I run my program, some of the forms will throw some…
James Oravec
  • 19,579
  • 27
  • 94
  • 160
0
votes
1 answer

Support UTF-8 in UniDAC( Firemonkey) for SQLite

Have next case: My App gathering data from MacOS X Mail with UniDAC for FireMonkey, but received data not support UTF-8. How can I set "Force Unicode" for UniDAC(SQLLite) by analogy with MyDAC components ?
YoungMaster
  • 395
  • 3
  • 17
0
votes
1 answer

error on delphi loading, after install UniDac componnent

i download UniDac component for delphi XE2 and installed it, now when run DelphiXE2 file i get bellow errors from delphi and when press ok, delphi load successfully but the UniDac component not installed. The errors listed include: bds.exe - System…
salman hedayatpoor
  • 13
  • 2
0
votes
1 answer

Creating new database using UniDAC

I have been struggling with a function that allows users to create a new db for my apps It has to be a universal function as some use MS Access, some SQLite and others MySQL I have spend hours looking in the supplied demo without finding anything of…
OZ8HP
  • 1,443
  • 4
  • 31
  • 61
-1
votes
1 answer

Some unicode characters are represented as "?" mark when inserting to Oracle from Delphi

I have written an application in Delphi 2010 that imports data from one database to another. I've done this before many times: From Access to Acces, Access to SQL Server. But now I have to import data from SQL Server 2005 to Oracle 10G. I do this by…
Mikayil Abdullayev
  • 12,117
  • 26
  • 122
  • 206
-1
votes
1 answer

Create table and auto increment column in Firebird with Delphi

I want to create table in Firebird embedded and set a column for auto increment, but I can't. I can create the table, but can't set a column for auto increment. I am using: Firebird embedded 2.5 Delphi xe3 UniDAC Componnent my SQL command: with…
M.Ghavam
  • 101
  • 4
  • 16
-1
votes
1 answer

Prevent inserting duplicate records

For the sake of learning I have created two identical tables in SQLite and was trying to figure out how to prevent inserting duplicates from one table to another. I am using this query in trying to find out if duplicates exist before posting the…
user763539
  • 3,509
  • 6
  • 44
  • 103
1 2 3 4
5
6