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!

  • Congratulations strongm 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: Bubsi
  • Order by date
  1. Bubsi

    Reporting concatenation of records

    If somebody has an idea how I can realize the following data output I would be very thankful. Table: Project Pos Description 100001 1 aa 100001 5 ad 100001 29 bf 100002 1 cd 100002 15 be 100002 23 nf 100002 24 xc Result: 100001 aa, ad, bf 100002 cd, be, nf, xc
  2. Bubsi

    Form: change color in a marked line

    Hi Lewy, that's what I'm looking for ! Thanks a lot.
  3. Bubsi

    Form: change color in a marked line

    Is there a possibility in a form to mark a selectetd line of data with another color. With a lot of data I lose the general view, which dataset is actually marked, if there is no possibility to mark them visible.
  4. Bubsi

    barcode 128 in report

    Now I found a simple method: -Install a barcode font; but be sure that the font works; there are many fonts for free download, but some of them didn't work correct. - change the actual font in your reportfield for your data into the barcode-font. - the most barcodes needs additional...
  5. Bubsi

    barcode 128 in report

    Has anyone experience using the barcode 128 in a paradox report. I have a number with 1 to 7 digits and want to print this number as a barcode on a report. The problem is how to calculate the checksum. If I'm right I need also a symbol for the start and the end of the barcode. Thanks Peter
  6. Bubsi

    Using additional characters in tables

    Hello Tony, I found the reason in a german forum: Paradox is not able to use unicode and the character "?" is only in the greek codeblock available. The only soluition will be to change to the creek language driver.
  7. Bubsi

    Using additional characters in tables

    Hello Tony, thanks for yor answer. But I don't know where I can see the language driver for the character. It's a normal PC with windows xp, language german. When I choose the charactertable in the font Arial I can choose this special character. Then I copy it into my paradoxtable. Hope I...
  8. Bubsi

    Using additional characters in tables

    I have problem with using in my tables additional characters like "?". The table views only "?". Is this a problem of the langdriver in the BDE ? Thanks for your help
  9. Bubsi

    Translation of sql commands from ansi to paradox

    Thanks Tony, the in the localsql.hlp i found a lot of informations. But I found nothing for the rownum command. Is there another possibility to give me a counting number back ? Example: Counting_Number Name Adress 1 Peter Street 1 2 Mike Blvd. 2 3...
  10. Bubsi

    Translation of sql commands from ansi to paradox

    Does somebody knows links, data, or something else where the ansi sql commands are translated in paradox sql commands. Example: what’s the paradox command for the ansi command "rownum" ? Thanks for your help
  11. Bubsi

    What is the latest version of Paradox

    I bought Paradox 11 in germany an the english version. That may be interesting for you
  12. Bubsi

    new version of paradox?

    I asked Corel directly. They told me that in professional edition Paradox 11 is encluded.
  13. Bubsi

    Filter in lookup forms

    Is it possibility to set a filter in a lookup-from ? I will use one lookup-form for different fields in a form. Is there a possibility to filter the data? I have prepared an example, which I can send, if necessary.
  14. Bubsi

    Sorting on a form with two tables

    Hi Lance, thanks for your help. But it won't work. Perhaps there is a problem with the linking of the two tables. Is it possible to send you my example ? Bubsi
  15. Bubsi

    Sorting on a form with two tables

    I have a form with data from 2 tables. The data of the main table I can sort by the indexes in the Record | Filter dialog box. But the data of the second table I can not sort in this way. There are also indexes on the second table. Is there a possibility to sort the data from the second table...
  16. Bubsi

    Using sql-commands in Paradox10

    Hello Lance, the documentation in the LOCALSQL.HLP was helpful. The correct command for substring(field,1,5)in Paradox is: substring(field from 1 for 5). Thanks Bubsi
  17. Bubsi

    Using sql-commands in Paradox10

    Exist a documentation about all available sql-commands in Paraodox 10 ? For example: In Oracle I use the command substring(field,1,5) In Paradox this command don't work.
  18. Bubsi

    Change Query in SQL

    Hi Carsten, thanks a lot. With the following code it worked without any problems. if billNo.value = "" then qBill = "''" ;get all bills else qBill = "'"+billNo.value+"'" ;only the bill you want endif
  19. Bubsi

    Change Query in SQL

    Hi carstenFH, thanks for your help but it doesn't work. Perhaps the ~qBill will be the problem. May I send you the complete commands?
  20. Bubsi

    Change Query in SQL

    I use the following code in a push-button method in a form. Now I want to use sql-commands but I don't know how to use the "qBill" variable in the sql commands. I have also problems to change the "if not qvar.executeQBE". Is there an equal command for sql ? The actual syntax...

Part and Inventory Search

Back
Top