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
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.
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...
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
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.
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...
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
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...
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
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.
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
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...
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
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.
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.