<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2668" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=900140411-06092005><FONT face=Tahoma size=2>Hi
List!</FONT></SPAN></DIV>
<DIV><SPAN class=900140411-06092005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=900140411-06092005><FONT face=Tahoma size=2>Environment
==</FONT></SPAN></DIV>
<DIV><SPAN class=900140411-06092005><FONT face=Tahoma size=2>WindowsXp for
Axiant 3.4D or D1</FONT></SPAN></DIV>
<DIV><SPAN class=900140411-06092005><FONT face=Tahoma size=2>Win2000 Server and
Sqlserver2000</FONT></SPAN></DIV>
<DIV><SPAN class=900140411-06092005><FONT face=Tahoma size=2>Powerhouse 8.41D/D1
although </FONT></SPAN></DIV>
<DIV><SPAN class=900140411-06092005><FONT face=Tahoma size=2>Compilations via
Axiant32 as above.</FONT></SPAN></DIV>
<DIV><SPAN class=900140411-06092005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=900140411-06092005><SPAN class=900140411-06092005><FONT
face=Tahoma size=2>These issues preface the replacement of many Omnidex features
embedded within a Hp3000 environment, so your experience and help is much
appreciated!</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=900140411-06092005><SPAN class=900140411-06092005><FONT
face=Tahoma size=2></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=900140411-06092005><FONT face=Tahoma size=2>A few Questions!
==</FONT></SPAN></DIV>
<OL>
<LI><SPAN class=900140411-06092005><FONT face=Tahoma size=2>A declare cusor
statement supports how many characters? I think it may be 255; given
compilation errors. We have since trimmied variable names to achieve ~230
with Ok compilations but reduced "parms" as passed from a calling
screen.</FONT></SPAN></LI>
<LI><SPAN class=900140411-06092005><FONT face=Tahoma size=2>Still needing
more; "Where" clause content; from the passed variables eg data ranges,
invoice ranges etc - lot's of "or t_var = blank"; I have used the Access
statement on the record cursor. The documentation suggests that this
supplements any pre-existing where clauses {as above} ie "and". It seems
to work.</FONT></SPAN></LI>
<LI><SPAN class=900140411-06092005><FONT face=Tahoma size=2>As I still need to
add more selects/where clauses to the new SQL; but before trying; some
assistance with respect to ::where_and etc substitution would be great! The
documentation reads well, but I am not positive as to where to create the
substitution strings - a define, a temporary - neither seem to work -
yet.</FONT></SPAN></LI>
<LI><SPAN class=900140411-06092005><FONT face=Tahoma size=2>Assistance with
the SET LIST SQL clause would also be handy. With Axiant, you can set this
statement for Quick screens within the active "Build Profile" - but where
does it go? I would like to see the resulting SQL as passed to the
server.</FONT></SPAN></LI>
<LI><SPAN class=900140411-06092005><FONT face=Tahoma size=2>And Lastly:! A
previous select clause used onb the Hp3000 using PH8 select syntax was : "and
if 0> index(Passed_Variable, column) i.e. is the Column value in the
passed_variable? so to speak. A pointer at specific SQL syntax would be handy!
The Passed_Variable contains a list of Customer_Codes, joined as
{abcd+your+comp}, a Customer_Code will always be a qualified "abcd", via
lookup noton stuff on the calling form. </FONT></SPAN></LI></OL>
<DIV><FONT face=Tahoma size=2><SPAN
class=900140411-06092005>Thanks</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2>Glenn Baxter</FONT></DIV>
<DIV align=left><FONT face=Tahoma color=#008080
size=1><STRONG>=======================</STRONG></FONT></DIV>
<DIV align=left><STRONG><FONT face=Tahoma color=#808080 size=2>Baxter IT
Solutions Pty Ltd</FONT></STRONG></DIV>
<DIV align=left>
<DIV align=left><STRONG><FONT face=Tahoma color=#808080
size=1></FONT></STRONG></DIV><STRONG><FONT color=#008080><FONT face=Tahoma
size=1><FONT color=#808080>e:</FONT> </FONT><A
href="mailto:glenn@baxterit.com.au"><FONT face=Tahoma
size=1>glenn@baxterit.com.au</FONT></A></FONT></STRONG></DIV>
<DIV align=left><STRONG><FONT face=Tahoma color=#008080
size=1>=======================</FONT></STRONG></DIV>
<DIV align=left><STRONG><FONT face=Tahoma color=#008080
size=1></FONT></STRONG> </DIV>
<DIV><FONT face=Tahoma size=2></FONT><FONT face=Tahoma
size=2></FONT> </DIV></BODY></HTML>