Search results for query: *

well, I thought I had tried any logical characters like single quote, double quote, back quote, brackets, parentheses and any combination of them ... but it didnt work. Then suddenly the double quotes seeemed to work!!! So I guess I have doen something wrong, but the solution is using double...

I have a table with field names containing minus-signs like art-fabr if i try to use these fieldnames in a SQL-statement of a TAdsQuery object it sees the minus sign as a minus sign and tell me it can't find the field "art" does anybody know a way to avoid this?? (by the way...

Thanks, that did the trick! Bas Schouten System Development & Webdesign CBIS BV Holland http://www.cbis.nl

In my application an MDI form is opened (child) with the following code: Form_Faktuur = TForm_Faktuur.Create(Application); The OnClose event of the form contains: procedure TForm_Faktuur.FormClose(Sender: TObject; var Action: TCloseAction); begin Action := caFree; end; Somewhere else...

Hello, In my application the user can use TAB-characters to format a textblock, the TAB's are saved in the database as Chr(09) characters (of course). But when i try to use this datafield (a DBF-memofield) in a report, it converts the TAB's to spaces, which of course doesnt give the same...

Hello, I want to create a new component derived fomr the TRichedit control. This new control will be expanded with some speedbuttons on top of the editwindow of the richedit control to control Bold an Underline styling of the text. I manage to create a new component beased on the TRichedit...

Well, if you are looking for code to delete just one row of the many that are the same ... DELETE TOP 1 FROM <table> WHERE <field1> = <value1> Guess if the DB-design would have correct, every tape should have been identifiable with a unique number, recorded as a field in the table, which you...

what exactly is the problem? Can't you find an answer in the ONline Books that are installed with SQL server? Bas Schouten System Development & Webdesign CBIS BV Holland http://www.cbis.nl

I'm not trying to do anything with the About property! I'v just added the control to an otherwise empty form, and try to run it. It seems that adding the directory where the unit for this VCL are located to the Searchpath seems to make a difference. But i'm not sure it has solved the entire...

I just installed an upgraded Crystal Reports VCL into my Delphi 4 enivronment. The new version is 7.4.0.51 If i add a tCrpe component to an otherwise empty project and run it i'm getting the following error when it tries to create the Crpe: Project Project1.exe raised exception class...

insert #temp EXEC StoredProc1 @Option Does this work?? Well thats a new one for me ... wish I knew this one before, it would have simplified some of the procedures I'v created :-) Thanks! Bas Schouten System Development & Webdesign CBIS BV Holland

You'll have to find a way to specify the exact row you want to change, by the contents of the fields and then using UPDATE ... WHERE field1='value1' and field2='value2' Bas Schouten System Development & Webdesign CBIS BV Holland

so it would be possible to create a Word-application object, open the .DOC file and save it like a .RTF file without ever showign the Word-windows ... than the RTF file can be opened and modified from within the Richtextbox Bas Schouten System Development & Webdesign CBIS BV Holland

My continuos searched has brought me to a page on the MSDN site which explains how to link a SQL-server to an Exchange database as a &quot;Linked server&quot; using OLE DB For Exchange ... but alas its aboutSQL server 2000 and Exchange 2000. we're using SQL-server 7 and Exchange 5.5 Any body...

Addendum to the previous post: A few possibilities that have crossed my mind: * could i create the Exchange Task-items from within SQL-stored procedure? (This would elimimate the task-table and move the task-data to the Exchange-database) * will i be able to read those tasks from within a...

We're building an application in VB with a SQL-server database. One of the functionalities of the application is the registration of tasks for certain users. These tasks are created when someone &quot;executes&quot; a procedure which effectively adds the tasks to an entity called Dossiers. At...

I'v got two tables SAL and DVB DVB contains info on a workingcontract SAL contains information historic salaries on those workingcontracts. The tables consists of the following columns: DVB: DVBDVBIDN (identity) DVBDVBDTB (startdate of contract) DVBDVBDTE (enddate of contract...

I'v noticed this problem occurs when I copy the .RPT file to a diferent computer, where the data and report files are in a different directory. Does Crystal use the absolute path of the linked database-files, or does it use paths to the report directory? Bas Schouten System Development &...

How much overhead does an open connection generate when it is not used with any recordset? And how much time does it take for a connection to open? Does anybody have any numbers or ideas on that? Bas Schouten System Development & Webdesign CBIS BV Holland

We've developed a product in Delphi 4 which makes extensive use of Crystal reports, using data from the Xbase (dBaseIV) datafiles from the product. Every now and then when i'v changed something in the reports, or have copied the reports from the develop-environment to a production environment...