Re: field alias

From: Anders Altberg (x_pragma_at_telia.com)
Date: 12/03/04 

Date: Fri, 3 Dec 2004 16:56:23 +0100

Hello Mohammed,

If you tables are in a VFP database or are a view then you can set the
Display Caption property in the Table Designer window to 'Dept. name' or
whatever with spaces. This caption will be use in Browse windopws and as
default for a grid column header caption
Open with MODIFY STRUCTURE or through the database Designer and you can make
the change if you have the table and database opened exclusive.

-Anders

"Mohammed Abdel-Razzak" <MohammedAbdelRazzak@discussions.microsoft.com>
wrote in message news:730BD4D8-5433-431E-8A86-8DBFC837671C@microsoft.com...
> Dear sirs
> I'm trying to make an alias t my fields but these aliases have spaces as
> follows
>
> SELECT DEPTID as "dept id" , DEPTNAME as "dept name" FROM DEPTS INTO
CURSOR
> slctCurs
>
> it gives me a syntax error
> how can I fix that??
>
> thanks
> Mohammed

Relevant Pages

  • Re: Is there a maximum size of field caption property in a table?
    ... There are usually multiple possible design solutions. ... ComponentTypeID jumper block, connector, ... ... BLOBs), and properties such as Format, Caption, and Description that don't ... > be in the database than what is in this table. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Changing Switchboard Textbox Title Via Text Document
    ... The general principle is the same however you do this. ... in the frontend of your database create a new table ... the literal string "caption" in the ctl_item field ... Then in your switchboard in the code behind the form put the following ...
    (comp.databases.ms-access)
  • DefaultValue and Caption in Dataset Designer
    ... possibly workaround) why the DefaultValue and the Description (Caption) ... values dont come across to the dataset from a given database. ... database level not at the application level and it seems like poor ... very poor design. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Retrieving table field properties
    ... > properties like caption, description etc ... Description is exposed by the Jet ... the database: Jet is the database. ... Most of the other column properties can be read using ADOX, ...
    (microsoft.public.inetserver.asp.general)
Loading