Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ros
  • Order by date
  1. ros

    retrieving recordset-help needed urgent

    Disclaimer : I don't know oracle However, it looks to me like your test procedure doesn't return anything, merely sets the varable a. try: create or replace PROCEDURE TEST BEGIN SELECT empno from emp WHERE sal=1950; END; this should return a recordset containing field empno.
  2. ros

    Run QBE in method using alias

    try: if not qVar.executeQBE("test.dbf") then errorshow() endif and see if you get an errormessage Richie
  3. ros

    retrieving recordset-help needed urgent

    I've had the same message from mssql when running a Stored Proc. The solution was to edit the procedure and remove all output except the final table. Use SET NOCOUNT ON to get rid of all "xxx rows affected" lines and remove any print statements in the Procedure. HTH, Richie
  4. ros

    carriage returns

    I haven't tested this but ,have you tried vbCrLF? Richie
  5. ros

    i can't do a simple table lookup -- "higher table level required"

    I don't know if this is causing to your problem, but I'd avoid using "Type" as a field name. This is a keyword and might be confusing the issue. Richie "Supreme executive power derives from a mandate from the masses, not from some farsical aquatic ceremony." - also Dennis
  6. ros

    SQL Search

    You need parens around the field name. Also, don't you need the wildcard % ? strTest = "SELECT MAX(PurchaseOrderID) FROM PurchaseOrder WHERE PurchaseOrderID LIKE '" & _ left(strPONum,5) & "%'" HTH, Richie
  7. ros

    Hi all, I will try and explain m

    On second thoughts scratch that last reply. You don't need the thickness field in the parts table at all. Why repeat the data if the plateID will give you the part thickness anyway? If you need to find out the thickness of the part you should be able to get it from the plate table linking by...
  8. ros

    Hi all, I will try and explain m

    If I understand your problem correctly, you could try linking the tables with both (ID and thickness) fields. You may have to restructure one or both tables to make thickness part of the primary key. This way items in the parts table must have the same thickness as the plate. Try it on a copy to...
  9. ros

    Add "To and From Dates" on the Report Header / Paradox

    There are several ways of doing this but the simplest is to edit the report and add a text object (called eg.daterange) where ever you want it. Save but don't deliver the report. In your pushbutton r.load("reportname.rsl", winstylehidden) r.daterange.text = "From " +...
  10. ros

    Paradox Queries

    Have you looked at INSERT queries? This will place the results of your query into a predefined table of your own design. Assuming the fields fit. Richie
  11. ros

    Spliting field value into 2 columns.

    This is because you have data that is not conforming to the nnnXnnn standard, probably blank. Check the size or the array before trying to reference it oldNums.breakApart(arDims,"X") if arDims.size() = 2 then tcDims."Width" = arDims[1] tcDims."Thick" =...
  12. ros

    Table repair with ObjectPal code

    I don't use this myself but, if you feel like playing around with it the form tutil32.fdl is what the menu calls. So to rebuild the answer.db with minimal user interface: var f form endvar f.open("c:\\program files\\borland\\paradox\\tutil32.fdl", winstylehidden) f.fldTable =...
  13. ros

    Running Report off Form Filter

    I just noticed from an earlier post of yours that you probably don't have the filter variable. In this case use getgenfilter in the form. var r report criteria dynarray[] anytype endvar ; capture the filter criteria -tableframeobject-.getgenfilter(criteria) ; the rest is the same...
  14. ros

    Running Report off Form Filter

    Another simple way is to apply the exact same filter to the report. eg. var r report endvar ;assuming you've already set up filter in criteria ; load report hidden in design mode r.load(-reportname-, winstylehidden) ; note: report must be .rsl not delivered r. -tableframename-...
  15. ros

    Date range using setGenFilter

    mtstad, FYI the most common reasons is see for problems in filtering or querying for date ranges are 1. Get No results : a. There really are no matches (most common reason) b. Mixing up >,< eg. &quot;<12/31/2001, >2/1/2002&quot; 2. Get Everything in table: using OR instead of...
  16. ros

    Date range using setGenFilter

    What kind of trouble are you having? Seeing nothing, seeing everything? This kind of code should work: daCrit[&quot;Date&quot;] = &quot;>12/31/2000, <2/1/2001&quot; tc.setgenfilter(daCrit) If this is what your date field filter looks like then you may have a problem in another field. Post some...
  17. ros

    Table update question.

    You could use the master table in the form and apply a filter to it. var f form daCriteria dynarray[] anytype endvar contnum = 0 contnum.view(&quot;Enter A Contract Number:-&quot;) strnum = 0 strnum.view(&quot;Enter A Structure Number:-&quot;) daCriteria[&quot;Cont#&quot;] = contnum...
  18. ros

    Paradox. 10

    Personally I've never felt the need to go beyond 7. There just wasn't anything compelling (to me) added in later versions. I just keep the BDE up to date. ros
  19. ros

    Calculating Age

    Another date to try is 12/31/2001. Year subraction will give an age of 1 to a newborn less than 2 weeks old. Correct age of 0 will be given by the suggested algorithm. ros
  20. ros

    Calculating Age

    >>That is, if you enter 02 as year, Podx treat it as 1902, not 2002. This is not the case in paradox 32bit. Your examples disprove your point not prove it. if you enter 1/1/61 paradox treats it as 1/1/2061, CURRENT century as I stated. The calculation is correct 2002 - 2061 DOES EQUAL -59...

Part and Inventory Search

Back
Top