Delphi Pages Forums  

Go Back   Delphi Pages Forums > Search Forums

Lost Password?

Showing results 1 to 50 of 178
Search took 0.13 seconds.
Search: Posts Made By: Claude
Forum: General 10-31-2006, 01:09 PM
Replies: 4
Views: 5,022
Posted By Claude
RE: SQL Server decimal datatype

Like previously said, the float type is not appropriate, mianly because it only holds 8 bytes of data. So you can have values like 123.1234567890 or 1234567890.123 but not 1234567890.1234567890 (more...
Forum: General 10-31-2006, 07:19 AM
Replies: 4
Views: 5,022
Posted By Claude
RE: SQL Server decimal datatype

BCDs are truncated after the fourth decimal. If, for example, I create a Decimal(24, 8) field in SQL server and I set a value of 123.456789 to this field, reading and writing it as a BCD will...
Forum: General 10-30-2006, 01:04 PM
Replies: 4
Views: 5,022
Posted By Claude
SQL Server decimal datatype

Delphi's ADO implementation lacks support for high-precision SQL Server decimal datatype. This is mainly because Delphi's own high precision datatype, FmtBcd, is not mapped in AdoDb.pas.

On...
Forum: General 05-10-2004, 01:11 PM
Replies: 5
Views: 7,283
Posted By Claude
RE: TDateTime initial value

TDateTime being a double, its default value is 0, which is December 30, 1899, but I learned to never trust the content of a variable I left unititialized.

In the previous exemple, try declaring...
Forum: General 04-30-2004, 10:13 AM
Replies: 1
Views: 750
Posted By Claude
RE: BLOB

I always read and write blobs as strings like:

string := Dataset.FieldByName('MyBlob').AsString;
Dataset.FieldByName('MyBlob').AsString := string;

Now, the problem is how to convert an image...
Forum: General 04-19-2004, 02:50 PM
Replies: 2
Views: 1,821
Posted By Claude
RE: De-referencing pointers??(!)

Your procedure "TForm1.handle_node" receives the node as an argument and I find it risky to save the address of this argument in what will be a "permanent" list.

I (seldom) use AddObjects to embed...
Forum: General 04-19-2004, 02:42 PM
Replies: 1
Views: 920
Posted By Claude
RE: Work with WORD documents

Where W, Filename and Fileformat are OleVariants,

W := CreateOleObject('Word.Application');
Filename := 'c:\sample.doc';
W.Documents.Open(Filename, EmptyParam, EmptyParam, EmptyParam,...
Forum: General 03-18-2004, 12:11 PM
Replies: 1
Views: 1,432
Posted By Claude
RE: How to compress bmps in a table?

I use TCompress (www.spis.co.nz) and I know there are other components perform similar functions.

TCompress can compress and expand files, streams and strings. They provide data-aware components...
Forum: General 03-03-2004, 09:00 AM
Replies: 2
Views: 2,742
Posted By Claude
RE: Copy component

You should take a look at the TypInfo unit. It contains procedures and functions like GetPropValue, SetPropValue and GetPropList. These procedures and functions allow you to manipulate properties of...
Forum: General 01-30-2004, 01:41 PM
Replies: 1
Views: 671
Posted By Claude
RE: SQL Statement using JOIN when data is different dir ?

This is easy to do with SQL Server (and you should stop developing on MsAccess. SQL Server is more performant, more robust, and you can freely distribute the five users version (called MSDE))

So,...
Forum: General 01-23-2004, 01:35 PM
Replies: 1
Views: 750
Posted By Claude
RE: BDE and Oracle (8i and 9i) Homes

Hello again!

Only one advice for you: Get rid of the BDE. Even Borland guys have been admitting for years that the BDE has no future.

ADO is faster, easier to distribute, and way more robust....
Forum: General 01-23-2004, 01:32 PM
Replies: 1
Views: 1,334
Posted By Claude
RE: Delphi+Oracle8i -- Columns Min and Max.

We had all sorts of problems when porting a MS SQL Server application to Oracle. The application is using ADO.

What solved some of these problems was to install Oracle 9i client on every client...
Forum: General 01-08-2004, 01:55 PM
Replies: 1
Views: 1,200
Posted By Claude
RE: What are COM, DCOM and OLE exacly ?

You are right in what you know. As far as I am concerned, OLE, COM and Activex are basically the same technology. When OLE started to have a bad reputation, mainly because it was slow and far from...
Forum: General 12-30-2003, 08:46 AM
Replies: 3
Views: 2,190
Posted By Claude
RE: serial comunications

I use TSerial, by Rick Crowther.

You can download evaluation versions on most Delphi components forums.

Mr. Crowther email address is rick@rjc.org.uk
Forum: General 12-30-2003, 08:42 AM
Replies: 2
Views: 3,968
Posted By Claude
RE: iterating through a dataset

Whatever the logic used, always remember to call the "DisableControls" of your dataset before iterating. Things will run about three times faster.

Going without iteration is always an order of...
Forum: General 12-30-2003, 08:35 AM
Replies: 1
Views: 759
Posted By Claude
RE: What is the problem with this SQL?

In your sub-select, "pi.codnota=pc.codnota" is an unnecessary condition. Try the following statement:

select p.codigo, p.descricao,
(select sum(pi.quant) from pediitem pi
where...
Forum: .NET 12-22-2003, 02:11 PM
Replies: 4
Views: 3,421
Posted By Claude
RE: Finally - .NET - what is it for and what does it do ?

The .Net framework is the natural evolution of Windows. You can design a graphic application without Windows (Autocad, for example, was working in DOS), but it is easier and the result is more...
Forum: General 12-19-2003, 08:03 AM
Replies: 1
Views: 1,073
Posted By Claude
RE: BDE And MSSQL

I know it may be unpleasant to hear but here it is: Forget about the BDE.

The BDE was an attempt to access various databases with a common set of components. Even though it is a good product,...
Forum: General 12-04-2003, 06:37 PM
Replies: 1
Views: 793
Posted By Claude
RE: a trackBar rotated in 45 degrees

Unless you find a control that already does that you will have to program it yourself (and you may find it fun too!).

Basically, what you have to do is draw on a form canvas what looks like a...
Forum: General 11-21-2003, 06:09 AM
Replies: 1
Views: 907
Posted By Claude
RE: Query problem

No you can't.

TQuery, TADOQuery can only execute statements up to a certain degree of complexity.

You cannot, for example, execute a statement that contains a DECLARE or a IF..ELSE..END. You...
Forum: General 11-18-2003, 06:01 AM
Replies: 6
Views: 968
Posted By Claude
RE: Second attempt: How to deploy from the web?

also, InstallShield allows you to build "packages for the web" that reside on a server and are downloaded and installed within Internet Explorer.

Maybe that is more what you are looking for (and...
Forum: General 11-18-2003, 05:56 AM
Replies: 2
Views: 1,083
Posted By Claude
RE: Concurrent database query - how?

Concurrent sessions will allow you to perform separate transactions but that's about the end of it.

Wether two sessions run concurrently on the same station or on two different stations does not...
Forum: General 11-18-2003, 05:41 AM
Replies: 6
Views: 968
Posted By Claude
RE: Second attempt: How to deploy from the web?

Microsoft.Net fully supports the concept of web-deployed applications. Moreover, a .Net application is relatively small (since a 30Mb framework must be installed on the client machine).

Therefore,...
Forum: General 11-17-2003, 08:18 AM
Replies: 3
Views: 979
Posted By Claude
RE: Reseau and password

Si le poste sur lequel la base de données est située est protégé au niveau du BIOS de l'ordinateur, je ne connais aucun moyen de solutionner votre problème puisque ce genre de protection existe...
Forum: General 11-15-2003, 09:33 AM
Replies: 1
Views: 768
Posted By Claude
RE: Word processor project

Check WPTools (http://www.wpcubed.com/index.htm).
Forum: General 11-15-2003, 09:29 AM
Replies: 3
Views: 979
Posted By Claude
RE: Reseau and password

J'ai besoin de plus d'information afin de vous aider.

Quelle est la base de données? (MsAccess, DBase, SQL Server, ...)

Quand vous dites "Protected by password", parlez-vous du mot de passe de...
Forum: General 10-28-2003, 09:52 AM
Replies: 1
Views: 895
Posted By Claude
RE: multi access to access

Here is a typical connection string of a TADOConnection object (Delphi 6)

Provider=Microsoft.Jet.OLEDB.4.0;
User ID=Admin;
Data Source=C:\Test.mdb;
Mode=Share Deny None;
Extended...
Forum: General 10-17-2003, 09:49 AM
Replies: 1
Views: 1,419
Posted By Claude
RE: Link DELPHI & Microsoft WORD & SQL server database

The first thing to do is to extract (text) from the word document. The "classic" way is to use OleAutomation with code like:

var v : variant;
...
v := CreateOleObject('Word.Application');...
Forum: General 08-29-2003, 02:06 PM
Replies: 2
Views: 811
Posted By Claude
RE: wat's difference?

There is no difference as long as memory mapping or speed of execution is concerned.

Using the type "double" directly makes your code more readable but using "tanyth" allows you to subsequently...
Forum: General 08-29-2003, 02:04 PM
Replies: 1
Views: 1,056
Posted By Claude
RE: Translate C headers to Pascal

Check "Calling convention" in Delphi's help and you will see that Delphi has equivalents for most of these types.

Do not worry a lot about these types since they are not relevant for functions...
Forum: General 08-29-2003, 01:51 PM
Replies: 1
Views: 1,178
Posted By Claude
RE: interface not supported D5/pcAnywhere....

Just a comment on your problem.

I was using a lot of early binding in my applications (mainly with Microsoft Office products), using Borland-supplied servers. When I installed the .Net framework...
Forum: General 02-24-2003, 03:11 PM
Replies: 1
Views: 4,891
Posted By Claude
RE: Excel | Copy | Clipboard ----> Paste into Delphi stringlist

You have to do some string parsing.

First, retrieve the data like:

var s, t : string;
...
s := Clipboard.AsText;

When the clipboard contains rows from excel, colums are separated with tabs...
Forum: General 02-21-2003, 10:58 AM
Replies: 1
Views: 908
Posted By Claude
RE: my App is congealed....

Since you call Application.ProcessMessages only on time per table, your timer will only fire one time per table.

If you want your users to see a progress bar moving while a table is being...
Forum: DB-Aware 11-26-2002, 04:32 PM
Replies: 1
Views: 1,410
Posted By Claude
RE: Export TDBGrid to MS Excel ?

Having Excel installed on your computer, use Ole Automation.
You can either do it the hard way (i.e. CreateOleObject('Excel.Application');) or use the components provided by delphi in the servers...
Forum: General 11-15-2002, 11:20 AM
Replies: 2
Views: 2,258
Posted By Claude
RE: pdf - how to count pages

Addendum: Most methods of the Acrobat Ole Objects will not work with Acrobat Reader but will work with Acrobat Approval, a low-cost version of Acrobat that stands between the Reader and the full...
Forum: General 11-15-2002, 11:16 AM
Replies: 2
Views: 2,258
Posted By Claude
RE: pdf - how to count pages

var PDFDoc : OleVariant;
...
PDFDoc := CreateOleObject('AcroExch.PDDoc');
PDFDoc.Open('c:\document.pdf');
ShowMessage(IntToStr(PDFDoc.GetNumPages));

Read more in:...
Forum: General 11-07-2002, 08:29 AM
Replies: 3
Views: 915
Posted By Claude
RE: ADO, SQL, ACCESS

I dont. As far as I know, dates are a pain in the butt. Try to avoid using date constants in SQL statements. Rather than writing

SELECT * FROM MyTable WHERE StartDate >= '1990.01.01'

write
...
Forum: General 11-05-2002, 03:20 PM
Replies: 3
Views: 915
Posted By Claude
RE: ADO, SQL, ACCESS

In similar situations, I start my application with SQL statements in try..except..end constructs.

So, with code similar to

SQL.Add('SELECT ... WHERE ... #');
try
Open;
...
Forum: General 08-30-2002, 07:49 AM
Replies: 1
Views: 744
Posted By Claude
Zooming the content of a TWebBrowser

I use a TWebBrowser to display a HTML document. I would like to add navigation and zooming functionnalities but the TWebBrowser seems to be short of methods and properties that would allow them.
...
Forum: General 07-11-2002, 02:31 PM
Replies: 1
Views: 786
Posted By Claude
RE: Mouse co--ords on StatysBar

Record the position in a variable during a OnMouseMove event and update your status bar using an idle handler (Application.OnIdle).
Forum: General 09-12-2001, 11:43 AM
Replies: 9
Views: 4,023
Posted By Claude
RE: DateTime compare question

Was the FileAge function returning the same result?
Forum: General 08-13-2001, 07:10 AM
Replies: 2
Views: 1,224
Posted By Claude
RE: What's wrong with my code

Since some elements (FInisialisasi, FInputan) are missing, it is difficult for me to run your program on my computer. Zip the entire project and email it to me at claude_martel@videotron.ca if you...
Forum: General 07-04-2001, 03:00 PM
Replies: 2
Views: 937
Posted By Claude
RE: Huge table in access

Usually, DB Grids only load the required amount of records to fill the visible area. This makes scrolling slow but filling fast. You have to use dynamic cursors to benefit from these.

If you go...
Forum: General 06-20-2001, 07:24 AM
Replies: 4
Views: 2,037
Posted By Claude
RE: Is Delphi right for me???

At university, you will learn about theory of information and theory of languages and I do not believe that you can really understand the guts of a language if you have no points of reference.

The...
Forum: DB-Aware 06-15-2001, 11:29 AM
Replies: 1
Views: 1,479
Posted By Claude
RE: Different dBase III+ file types?

I think that the data file (DBF) is the same but variations exist regarding Memos and Indexes. When I have to manage XBase files, I use Halcyon (www.grifsolu.com). It handles everything perfectly.
Forum: DB-Aware 06-13-2001, 05:40 PM
Replies: 3
Views: 1,631
Posted By Claude
RE: RE: RE: Select ODBC Datasource from your application.

Having use ODBC Express for a while (I am now an ADO addict!), I know that they provide a component that retrieves ODBC Datasources for you. Now, I still suppose they find them in the registry.
Forum: General 06-13-2001, 09:08 AM
Replies: 1
Views: 3,889
Posted By Claude
RE: TPdf component (Acrobat reader)

Found the answer!

Adobe wants to sell the full version of their Acrobat product so the end-user licence agreement of Acrobat Reader forbids any attemp to save the pdf.
Forum: DB-Aware 06-13-2001, 09:06 AM
Replies: 3
Views: 1,631
Posted By Claude
RE: Select ODBC Datasource from your application.

This information is stored in the registry. Since the path will vary from depending on the OS, the simple way is to create a dummy entry in the ODBC manager (like "BozoTheClown") and then search for...
Forum: General 06-07-2001, 11:09 AM
Replies: 2
Views: 841
Posted By Claude
RE: Is it posible...?

If you mean compiling and calling at runtime a function defined in a text file take a look at DreamScripter (www.DreamCompany.com)
Forum: General 06-07-2001, 10:02 AM
Replies: 1
Views: 3,889
Posted By Claude
TPdf component (Acrobat reader)

Does anyone know how to programmatically save the PDF document being edited by the TPdf activex component?

There is a "src" property that correctly loads a file and a "LoadFile" method that does...
Showing results 1 to 50 of 178

 
Forum Jump

All times are GMT. The time now is 12:48 PM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.