Search results for query: *

How can a pass an SQL text greater than 255 characters that has been stored in a table to the SQL property of a QueryDef? In many words: I have a table where I store the SQL to generate a report, field name is SQL2Use - a memo field as some of the SQL is quite long. In my code I store the...

Hi, I am trying to use formula templates in my application I have table with the formula templates for different scenarios. TableName = CorrRules. Each scenario has a scenarioID in this table. One of my formuala templates is [ProbVar]&" == " & [ProbVal]. This is stored in the field...

Hi, This might be a long read, but I need you to understand my problem properly so that you can help on how to EVALAUTE A STRING EXPRESSION IN AN ACCESS QUERY. I am writing a data cleaning application for my office, I work in a medical research organisation, using Microsoft Access 2003. I...

Hi, I am creating a report that I want to run in a custom window. Below is the relevant code snippet: ... DEFINE WINDOW wReport FROM 20,3 TO 90,130 IN DESKTOP TITLE 'MITU DMSS Reports' SYSTEM CLOSE FLOAT NOMINIMIZE REPORT FORM S:\CodeVFP\Reports\Corrections PREVIEW WINDOW wReport NOWAIT...

Hello all, When you create a database application with ms access as the 'backend' (getting data using TADOQuery) do the clients pull the entire database over the LAN or just the records specified by the sql? If the clients pull the entire database across and execute the query locally, what can...

Hello, I have an array arForm[1..15, 1..3] I would like to find the position of an element in this array. (This array element is always in the 1st 'column' of my array.) Suppose arForm[1,1] is 'Delphi'; arForm[2,1] is 'Inprise' and arForm[3,1] is 'Borland. I want to be able to do something...

Hello, I am trying to learn how to create multi-tiered applications in Delphi. I looked up 'Creating Multi-tiered applications' in Delphi help but found it difficult to follow for a novice like me. ( i have created a few 'normal' database apps for the office so am not completely ignorant on...

Hello, I need to export data from an access query into a comma delimited text file. I then need to import that file into an access database on a different computer. (This is done every day, data from 15 different computers is imported into one computer) We currently do it in Access by running...

Hello, I just finished an app that i want to deliver to the client. I want the database to be password protected (MS ACcess 2K) I set the password in access, no problem. In Delphi when i set the password in the ADOConnection dialog and test the connection, i get a message 'workgroup...

hello, am using ADO and Delphi6 How do i get the directory in which the database (.mdb) is in from a TADOConnection?? TIA

Hello, I have this code snippet: ... MessageDlg('Member not allowed to borrow' + #10#13 + 'Allow any way?', mtConfirmation, [mbYes, mbNo], 0) ... This shows a dialog box with 'YES' as the Focused button. I want "NO" to be the focused button!! I tried [mbNo, mbYes] but it did not...

Hello all. I need to show an image in my apps main form (WindowState = wsMaximised) So i drop a TImage on the form, set picture property to my picture (resolution is 800 x 600, size is 141 x 107, format is jpg, bmp) When i set the streched property to true, the image blurs!! My screen...

Hi All, I need to round a number to nearest 0.5 Round() allows me to round to x significant digits. I want it to the nearest 0.5 Any ideas?? cpmasesa

Hello, 1. how can i have focus set to the 3rd (or any other) column in a dbgrid? 2. How do i achieve autocomplete (ie typing moves to record nearest matching typed string) on the embedded tcombobox that is created in a dbgrid if the underlying field is a lookup field TIA Clemens

I have a query in MSAccess2K which expects 3 parameters. In my delphi app i connect to the query using a TADOStoredProc. when passing parameters, the following DOES NOT work: with Orders do begin //this is the TADOStoredProc Close; Parameters.ParamByName('DateFrom').Value :=dpFrom.Date...

Hello ALL, I would like to write a query that will return records within a given date range (simple enough) BUT the date field queried varies!! My Table has oDate, tCompleted, tDelivered, aCompleted and aDelivered as Date fields To return records where oDate is btn two dates i have the...

Hello ALL, i have made a database app and want to improve the functionality of the user interface. In 'edit' forms i used TDBEdit. I want to change color of an edit control IIF that field has been changed by the user (edited). How can i do this?? I cannot find an AfterEdit event on TField...

Hi, How does one include comments in the SQL you write in MS Access? TIA cpmasesa

Hi, I am writing a database app with D6 and Access2k using ADO. Sometimes when i attempt to delete or post a record through the application i get an exception. i would like to respond with my custom messages depending on the exception: 1. missing required fields, 2. missing master table...

Hi, I have the following function: procedure TfrmReports.ssShowReport(sReportFile : string; aReportDataSet : TADOQuery; arVariables, arValues : Array of string); var sAppPath : string; i : integer; begin sAppPath := ExtractFilePath(ParamStr(0)); dsReports.DataSet := aReportDataSet...