Search results for query: *

Hi, This thread Thread144-343115 might help. Cheers.

Hi, Have a look at: http://www.javaworld.com/javaworld/jw-03-2000/jw-0324-javaperf_p.html Cheers.

Hi, There is a profiling tool available from with PB. Look in the help files under 'profiling'. Use the database profiling tools for the SQL, or use the trace log made available by the ODBC drivers. This can be accessed with in the ODBC administration program. Cheers

Hi, Try altering the CallEscape and DisableBind parameters for the DBParm attribute of the transaction object. They take the following values: CallEscape : 'Yes'/'No' DisableBind : 0/1 itr_source.DBParm = "DisableBind=1,CallEscape='No',ConnectString='DSN=DBdsn;UID=DBA;PWD=SQL'" Cheers

Hi, Is there any reason why you cannot upgrade entirely to 6.5.1? I remember this being a more stable product than 6.0 Cheers.

Hi, Check the class of the variable holding your count - integers can only count up to 32768. Cheers.

Hi, PB will sensibly export a composite datawindow when you use a SaveAs type of PSReport!. There are a number of PSR viewers available as freeware. See the usage notes in the PB help on SaveAs Cheers.

Hi, Try specifying a length in your cast/convert. What I meant was if you know for a fact that the users will only ever enter 2000 characters (or whatever) you could safely specify a limit on the conversion. If none of this works you may need to use a composite datawindow, and retrieve the...

Hi, Ignore the previous post, I've just read your post correctly now. A basic UNION will perform a DISTINCT anyway, because by default the UNION operator returns the unique rows unless you specifiy UNION ALL. So the SQL is trying to do a unique operation on the text column and failing. You...

Hi, I have no idea about this other than: do you have the EASDemoDB database installed? Cheers.

Hi, Are any of the columns being retrieved of type text, ntext or image? Do you get a different result if you specify UNION ALL? Cheers.

Hi, If you start your ftp session with the -i command line argument you will turn off interactive prompts. Then your mdelete will not ask for confirmation. http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/winxppro/proddocs/ftp.asp Cheers.

Hi, Couldn't you then have two arguments to the datawindow: al_high and al_low and have your SQL in the child datawindow as SELECT * FROM x WHERE x.num >= al_low and x.num <= al_high then programmatically decide how to populate the arguments i.e. if only one value is supplied, populate both...

Hi, Sorry, I meant child datawindow not datastore. So your datawindowchild dataobject possibly could be driven from a stored procedure, which could use a variety of methods to construct its own query sql (say from temporary tables populated with the users' choices) which would then return the...

Hi, Maybe you could use a stored procedure to drive your child datastore and pass relevant arguments. Not that I've tried that, mind. Cheers.

Hi, Have a look at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sysinfo/base/exitwindows.asp You'll need to code an external function declaration for this: Function boolean ExitWindowsEx (Long dwOptions, Long dwReserved) Library &quot;user32&quot; Alias For...

Hi, Une des options en éditant le datawindow SQL sera obligé à déclarer les arguments de récupération. Ceux-ci sont fournis au datawindow comme ceci: dw_1.Retrieve(arg1, arg2). Cheers

Hi, Try something like: boolean lb_Value lb_Value = (String(a_local_datastore.object.field_name[1])=&quot;YES&quot;) struct.boolean = lb_Value Cheers

Hi, Use a window of type popup, but after opening it, setfocus() back to the main window i.e. (this code is in a button on the main window) open(w_popup) parent.setfocus() You can position the popup in its open event. Cheers

Hi, If I understand you correctly you are using the application to enforce user data rights. If this is the case, and your users are not restricted at the database side then there is not a lot you can do about &quot;backdoor access&quot;. To control the users via any connection i.e. at the...