2. ASPRunnerPro General questions
  3. format chart
This topic is locked

format chart

 		4/4/2006 11:09:45
ASPRunnerPro General questions
virtualbox author

is it possible to format the contained text in a chart with the first capital letter? or all in capital?
the text has been translated by Italian into English with a program, excuse for possible errors <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2711&image=1&table=forumtopics' class='bbcemoticon' alt='<<' />
Sergey Kornilov admin 4/5/2006

Hi,
to make text output to uppercase do following:

  1. proceed to the Edit SQL Query tab, check off Edit SQL query manually checkbox and edit SQL query. See my example:

select [fieldname1],

[fieldname2],

ucase([fieldname2]) as fieldname2Uppercase

From [tablename]



2. Proceed to Choose fields tab, for fieldname2 field select following checklists: Search, Adv Search, Add, Edit.

Correspondingly for fieldname2Uppercase field: View, List, Printer, Export.

3. For fieldname2Uppercase field change label value to fieldname2 on the Formatting Tab and then rebuild your project.
virtualbox author 4/6/2006

does it excuse Sergey you make me a practical example?
-> OK Edit SQL Query Manually
select [ID],

[Uffice],

[TypeVehicle],

[crew]

From [Db_register]
the whole text in the charts is formatted in capital
thanks for the availability, good product, compliment!
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=8917&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />
Sergey Kornilov admin 4/6/2006

Hi,
see my example:

select [ID],

ucase([ID]) as IDUppercase

[Uffice],

ucase([Uffice]) as UfficeUppercase

[TypeVehicle],

ucase([TypeVehicle]) as TypeVehicleUppercase

[crew],

ucase([crew]) as crewUppercase

From [Db_register]
E
 		enetsat 8/20/2007

Hello for all
When I try make this EXAMPLE sy one error
select [Código],

ucase([Código]) as CódigoUppercase

[Nome],

ucase([Nome]) as NomeUppercase

[Endereco],

ucase([Endereco]) as EnderecoUppercase

[Tel]

ucase([Tel]) as TelUppercase

From [1]
The error Say CANNOT RETRIEVE COLUMNS INFORMATION . PLEASE MODIFY SQL QUERY AND TRY AIGAIN
some can helpme ?

thanks for all
Sergey Kornilov admin 8/20/2007

You need to insert a comma after each field name:

select [Código],

ucase([Código]) as CódigoUppercase

[Nome],

ucase([Nome]) as NomeUppercase

[Endereco],

ucase([Endereco]) as EnderecoUppercase,

[Tel],

ucase([Tel]) as TelUppercase

From [1]
E
 		enetsat 8/21/2007

The program say the same messenge of error

CANNOT RETRIEVE COLUMNS INFORMATION . PLEASE MODIFY SQL QUERY AND TRY AIGAIN
why it hapen ?

thanks for you help

EWD

You need to insert a comma after each field name:


select [Código],

ucase([Código]) as CódigoUppercase

[Nome],

ucase([Nome]) as NomeUppercase

[Endereco],

ucase([Endereco]) as EnderecoUppercase,

[Tel],

ucase([Tel]) as TelUppercase

From [1]
Sergey Kornilov admin 8/21/2007

Put a comma after each field name except for the last one.