Recent content by BasSchouten

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...