Recent content by BetterLateThanNever

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.