parameter Posts

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: Offshoring Discussion « AmericanIT Board

{Too Long!}

Posted to MB Topic: General Client Board « Client Board

{Too Long!}

Posted to MB Topic: Coding Techniques « Coder Board

{Too Long!}

Posted to MB Topic: General Client Board « Client Board

I need to use the contents of a parameter to pull a field's contents. Visual FoxPro uses the & character for that sort of thing. Is there a Paradox equivalent? Edit: Fount it - it's called dereferencing, eg  sField = "Name"   ;Assign a field name to the variable., view(tcCustomer.(sField));Dereference the variable using parentheses. from:  https://www.prestwoodboards.com/ASPSuite/KB/Document_View.asp?QID=101169

Posted to MB Topic: ObjectPAL « Paradox Board

In this era of science and technology, computer science has been one of the most important, tools of development. A lot of things have changed since computers and the internet came into, the scenario. Communication has become an important parameter responsible for the, betterment of people’s lives. Most of the development is nowadays driven by computer science, and technology. This is the main reason why students now tend to select computer science for, their education. There is a plethora of job available in the software industry which is growing, each and every day.

Posted to MB Topic: Tech Writing « Tech Writer Board

{Too Long!}

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board

I am developing an application that uses Crystal Reports as the reporting mechanism. But I am having trouble in getting Delphi to pass a parameter to the report. Does nayone have any suggestions? Thanks.

Posted to MB Topic: Delphi Object PASCAL « Delphi Board

I need to use a (string) variable as a parameter for makeDir, but it only accepts a constant as a parameter. For example: n = 1 while n <4    stVar = "dirname" + string(n)    makeDir(stVar) endwhile How to get around this...?   Thanks! -pt

Posted to MB Topic: ObjectPAL « Paradox Board

Hi All, I've been having some fun trying to change the BDE 'block size' during run time. I need to generate large answer tables and I don't want to drag every user though the BDE Administrator. I have no access to their machines other than my software. I like the idea of only modifying the settings when my program is running instead of changing their idapi.cfg file.  "rptSession" is a TSession component in the below example. TStringList* tsl = new TStringList(); rptSession->GetConfigParams("\CONFIGURATION\DRIVERS\NATIVE\PARADOX\%s","BLOCK SIZE",tsl);, I can compile, and no matter what permutation of path I dictate, the engine can't find the parameter that I specify. I want to read the current block size, then modify it while the session is active. Thanks in Advance! Jim Shedden

Posted to MB Topic: C++Builder « C++ Board

I need to use a (string) variable as a parameter for makeDir, but it only accepts a constant as a parameter. For example: n = 1 while n <4    stVar = "dirname" + string(n)    makeDir(stVar)     n = n + 1 endwhile How to get around this...?   Thanks! -pt

Posted to MB Topic: ObjectPAL « Paradox Board

Attempting to add data fields to a table and I get invalid parameter error. Error refers to links between tables. I do utilize lookup tables on the form when adding data to this table which is functioning without any issues

Posted to MB Topic: Paradox Tables « Paradox Board

Is there a way to pass parameter to paradox sql file?  Something like:, , Update Table1 Set CurrentDate = ?, Update Table1 Set CurrentDate = :CurrentDate, Update Table1 Set CurrentDate = @CurrentDate, , All I found is this article:, https://stackoverflow.com/questions/12416503/delphi-query-parameter-usage-when-all-values-is-also-an-option

Posted to MB Topic: QBE & SQL « Paradox Board

{Too Long!}

Posted to MB Topic: VB Classic Database Tasks « VB Classic Board

{Too Long!}

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board

when i use NMHTTP1.Post('http://10.0.65.188/hello.php','a=hello'),the socket reply that the connection is successful,but the parameter hasn't been transfered., , who know why and how to deal with it?, thax.

Posted to MB Topic: Delphi VCL « Delphi Board

{Too Long!}

Posted to MB Topic: QBE & SQL « Paradox Board

{Too Long!}

Posted to MB Topic: ObjectPAL « Paradox Board

{Too Long!}

Posted to MB Topic: Object Orientation (OO) « Coder Board

{Too Long!}

Posted to MB Topic: MS Access Interactive « Access Board

I am submitting a query in an ASP page. , , It is a tow piece query and I am not sure the correct process to accomplish this., First I am , , , SQL ="SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &";", then the valuse returned from this query i would like to use it in the next query , , , SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 = (tring to use the value from the previous query here)", I tried to combine the select statement as below , , SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 = (SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &" ); " but I get the , [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. , , Can anyone offer some help.

Posted to MB Topic: ASP Classic Coding « ASP Classic Board

I am having a speed problem when writing new values to a MS Access table via and ADO connection.  On the first pass through the dataset there is no problem, with more than 1000 records per second being updated.  But on the second pass through, it slows to about 10 records per second, even though the task is much simpler. Just the fact that I try to update just one field seems to trigger the slow speed on the second pass.  I am using a TADOConnection and a TADOTable to connect to the Acces table.  To update the filed values I am using...    MyADOTable['MyFieldName'] := NewFieldvalue; Some parameters for the connection include... ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Mode=Share Deny None;Persist Security Info=False, CursorLocation = clUseServer, Provider = Microsoft.Jet.OLEDB.4.0 Can anyone suggest what might be causing the problem or any possible solutions.  Regards  Ron

Posted to MB Topic: Delphi Single User Apps « Delphi Board

I'd like to be able to reboot my systems from time to time. How can I do this thru OPAL?, , I found the following on the web somewhere for use in Paradox. But the reboot function does not work., , The only one I could get to work was Logoff., , Any ideas?, , I'm using Paradox 10 with Windows XP., , ;For this function there are several options for the first parameter :, ;0 : Logoff, ;1 : ShutDown, ;2 : Reboot, , Uses "user32.dll", ExitWindowsEx(uflags clong, dw clong), endUses, , method pushButton(var eventInfo Event), , exit() ;// Put here the code to close any Tcursors to prevent loosing data, , ExitWindowsEx(2,0), , endmethod, , I am under the impression that it will be beneficial for Windows systems that are basically running 24/7 to be rebooted periodically. Is this true, and can someone tell me why. If it's not necessary, I can drop this whole reboot topic all together., , Thanks!

Posted to MB Topic: ObjectPAL « Paradox Board

{Too Long!}

Posted to MB Topic: Paradox for Linux « Paradox Board

{Too Long!}

Posted to MB Topic: Paradox Third Party Software, DLLs, and Controls « Paradox Board

I'd like to be able to reboot my systems from time to time. How can I do this thru OPAL?, , I found the following on the web somewhere for use in Paradox. But the reboot function does not work., , The only one I could get to work was Logoff., , Any ideas?, , I'm using Paradox 10 with Windows XP., , ;For this function there are several options for the first parameter :, ;0 : Logoff, ;1 : ShutDown, ;2 : Reboot, , Uses "user32.dll", ExitWindowsEx(uflags clong, dw clong), endUses, , method pushButton(var eventInfo Event), , exit() ;// Put here the code to close any Tcursors to prevent loosing data, , ExitWindowsEx(2,0), , endmethod, , I am under the impression that it will be beneficial for Windows systems that are basically running 24/7 to be rebooted periodically. Is this true, and can someone tell me why. If it's not necessary, I can drop this whole reboot topic all together., , Thanks!

Posted to MB Topic: ObjectPAL « Paradox Board

{Too Long!}

Posted to MB Topic: Paradox Third Party Software, DLLs, and Controls « Paradox Board

hi, does anyone know, how to fix the following, problem?, , I have a Matrox Millennium G550 graphics card and use Borland Delphi 4.0. I have the newest driver and the newest Delphi version. The problem is, that for example the "Start (in engl. i think it should be RUN) - Parameter" - window is so small, that i cant type in some parameters. But the window isnt resizeable. I just can see the register "local" and a button "load". Thats in some other Delphi-Menues too ... , , If i start windows in "Protected Mode (i hope thats the name it uses in engl.) - you know F8 and then "Protected Mode" (for minimal driver-use) - you see the Parameter-Window in full size. (windows then uses the "standard-vga"-graphics-driver). Thats why i think, that the problem is with the Matrox Millennium G550., , Does anyone know how to fix this problem?, , I hope my english is well enough, too be understandable ..., , greets, necron

Posted to MB Topic: Delphi News / Other « Delphi Board

{Too Long!}

Posted to MB Topic: Paradox for Linux « Paradox Board

{Too Long!}

Posted to MB Topic: MS Access Interactive « Access Board

I am displaying customer details viz., , Name, telephone no, address etc, , When clciked on a row (og the grid having customer details) i want to dial the telephone number displayed., , I am using mshflexgrid and I know mshflexgrid1textmatrix function to fetch telephone no., , I want to know the function which will dial the telephone no i wil pass on as parameter

Posted to MB Topic: VB Classic Control Usage and Developing « VB Classic Board

I have recently made a successful use of importing a type library and installing the component produced. This works fine in D7, but I only have the desktop version, and I need to be able to do it in D6 to use database access., , Now in D6, the library is imported and a source file produced which theoretically could be installed as a component. There is an "Install" button on the import dialog. However, the source produced will not compile. The error is "Property setter cannot have var parameters"., , It seems odd that D6 produces source code on the import which the compiler cannot then compile. Does anyone have any experience with this, or know a work-around. My inclination is to add "wrapper" procedures which don't have var parameters., , Neville

Posted to MB Topic: Delphi COM / ActiveX / DCOM « Delphi Board

I have 5 final tables that I have to compare and update from 5 Temporary tables. Lets call the tables X, Y etc and the temporary tables TempX, TempY, etc. I only need to compare on the primary key of the tables. My problem is that each table has a different name for its primary key. How do I generalise my function to compare on the first column of all the tables and disregard their names so I can use the same function for all of them? Thus far I came up with this: scan tcTempX :, If tcX.qLocate(tcTempX.Xkey) then, Update(tcX), else, Append(tcX), endIf, endScan The qLocate compares in the key field already for tcX. Now I need to replace Xkey with something universal for when I pass tcTempY as a parameter to the function. In that case the Xkey will be invalid and should be Ykey. It would be easiest if I could simply make it use the first column in all the tables for comparison. Any ideas?

Posted to MB Topic: ObjectPAL « Paradox Board

Hi,, , I have parameter queries that pull sets of customers. I want to open Outlook and have all the emails address from the Email field automatically in the To field of a blank email message., , I've used the SendObject on a Macro to send a standard email message, but this will not work in this case, as the message will vary, depending on the user and the parameter query they run. That's why I want to open a blank Outlook message and have the emails from the query in the To field. The email message can then be composed by the user., , I am designing this for users who have no experience with the Macros, and actually don't even see the database design window. I will run everything from a form, the user will choose the query they want, Outlook will open, with the emails in the To field., , Is this possible thru some kind of Private Sub code??

Posted to MB Topic: MS Access Interactive « Access Board

Hiya!, , I created a button in a form that opens another form. Could you help me figure out how to pass parameters between those two forms? I'm trying to pass an "id" to the child form. The child form then gets a list with "id" as the default. I should then be able to pick from the list and modify the default and then pass the modified "id" back to the parent form. , , Please help., , Thanks!

Posted to MB Topic: ObjectPAL « Paradox Board

{Too Long!}

Posted to MB Topic: Delphi Single User Apps « Delphi Board

I was trying to get my head around sql query parameters but unfortunately the online help seems to kick in well beyond the basics and without any nice simple examples to learn from., , Can anyone offer a concise explanation and an example?, rt

Posted to MB Topic: Delphi News / Other « Delphi Board

I am submitting a query in an ASP page. , , It is a tow piece query and I am not sure the correct process to accomplish this., First I am , , , SQL ="SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &";", then the valuse returned from this query i would like to use it in the next query , , , , SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 = (tring to use the value from the previous query here)", I tried to combine the select statement as below , , , , SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 = (SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &" ); "but I get the , [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. , , Can anyone offer some help.

Posted to MB Topic: ASP Classic Coding « ASP Classic Board

Hi,, I am calling a C dll function from VB6. It's not showing any error when linking to the dll and the function is called properly. But when I print the parameter values inside the dll function, correct values are not found. , , the C function prototype is:, void Analyze_Data (char* goldFile, char* capturedFile, int tolerance);, , I am calling from VB as:, , Private Declare Function Analyze_Data _, Lib "U:\new-Viewer\Viewer\analysis1.dll" ( _, ByVal gold_file_name As String, _, ByVal capture_file_name As String, _, ByVal Tolerance As Long _, ), , Analyze_Data(gfile, capfile, tol), , When I print the values from the dll function, the first parameter is always emtpy, the second parameter is getting the value of the actual first parameter that is passed and third parameter is garbage., , Please let me know if anyone knows why the parameters are not passed properly.

Posted to MB Topic: VB Classic Other « VB Classic Board

I am having trouble calling a SQL Server 7.0 Stored Procedure from C++ that returns a recordset and an output parameter., , Here's the criteria - I wish to bind parameters at run time and I need to return an output parameter. Presumably, I need to use rs.Open not execute in order to get the recordset - the problem is that I don't get the output parameters if I am opening the recordset., The stored procedure may change so I don't really want to implement a static wrapper for it., I have tried to implement this with ADO, MFC DAO and MFC ODBC support classes., , A sample piece of code that does exactly what I need would be ideal...

Posted to MB Topic: MS SQL « DBA Board

I have proble with restructure table:, I have to add a field but after made instruction like hep of PDX9 i receive an arror that tells me parameter error., , Anyone hve some example to show procedure, , Thanks., Fernando

Posted to MB Topic: ObjectPAL « Paradox Board

I'm new to the COM scene, and don't know how to supply a pointer to the client's IDispatch interface to a COM server. When I don't provide this, the server behaves just fine when I call it, but crashes every time it attempts a callback. , , Below is the function call in question with the only documentation I have :, , function TMapper.RegisterWithMapServer(const client_name: WideString; window_handle: Integer; dispatch_pointer: OleVariant): Integer;, , "RegisterWithMapServer registers the map server client name and main window handle. Map server clients MUST call this function once at start up BEFORE calling any of the other functions. The parameter dispatch_pointer should be of type VT_DISPATCH and should contain a pointer to the client's IDispatch interface for the callback object.", , Thank in advance for ANY help!, , n

Posted to MB Topic: Delphi COM / ActiveX / DCOM « Delphi Board

{Too Long!}

Posted to MB Topic: Delphi Single User Apps « Delphi Board

I have experimented with the example listed on p. 407 of Mike's book where you can attach a table to an undefined table frame. I am using it in the context of running a query where query parameters are entered in an unattached field on the form and passed into a query. The Answer table from the query is then attached to the table frame on the form., It works well except that I don't seem able to control the display characteristics of the table. My table has a formatted memo field which always comes up in the form of a box in the table field which is too small to view easily. Any ideas on how these display characteristics can be controlled?, John Malcolmson

Posted to MB Topic: ObjectPAL « Paradox Board

Hi, , I am trying to open the recordset:, Set dbs = CurrentDb, Set rst = dbs.OpenRecordset("bill1"), , And get an error "TOO FEW PARAMETERS", , "bill1" is a query where I prompt a user to enter the criteria., , What could solve the problem?, , THanks

Posted to MB Topic: Access VBA Programming « Access Board

Hi,, , I have a like parameter query on the field course_name - Like "*" & [ Enter Course you are searching for:] & "*", , This query is the source for formCourceResult. I want to cancel the query if there are no results for the Value entered in the criteria., , I've tried this on the On Open event of the for but get a debug error. This is the code I've tried:, , Private Sub Form_Open(Cancel As Integer), , Dim rs As Recordset, Dim strsql As String, , strsql = "select * from qryCourseSearch where Course_Name = " & Value, Set rs = CurrentDb.Openrecordset(strsql, dbopensnapshot), If rs.RecordCount = 0 Then, MsgBox "No courses match your search", vbInformation, Cancel = True, End If, , End Sub, , Any ideas what is wrong?

Posted to MB Topic: MS Access Interactive « Access Board

Can I control the "ToolBar" parameters in my delivered Runtime package? I would like only the "status bar" to be available when the delivered package is run. I would also like to "maximize" the applications when they are opened from the shortcut that I place on the desktop of my users. I've gone thru the help section but am missing something.

Posted to MB Topic: Paradox Runtime & Distribution « Paradox Board

Hey there can someone help. I having having a problem with the keyPhysical event. What I want to do is when ctrl and x are pressed together I want to result to be a cut operation. I know that this is s default action, but I also want it to include the command action(dataBeginEdit) so that it will work every time regardless of what mode you are in i.e. view or edit. I have tried to do this using the following code, , if eventInfo.isControlKeyDown() and eventInfo.vChar() = "X" then, disableDefault, action(dataBeginEdit), eventInfo.setId(MenuEditCut), endIf, , However, this does not work as it says that setId has a parameter mismatch. Can someone tell me what I am doing wrong, or a way to solve this problem, Cheers

Posted to MB Topic: ObjectPAL « Paradox Board