Am I able to rename the table or field's name from database

Hi I have a problem when i connect to the Remedy Database.   The actual
name's table came up like weird name.  The table's name is like H12, T 30
then the fields in each tables like c1, c2 , c3.....
Do you think i could be able to rename those tables and fields names to
whatever i create, so the users can look at easily to create the reports??

Thanks again
pete


0
Pete
11/5/1998 5:51:33 PM
sybase.infomaker.general 4461 articles. 0 followers. Follow

4 Replies
427 Views

Similar Articles

[PageSpeed] 2

Sounds like you have a strange ODBC driver.   It doesn't recognize the table
structure, so it considers all the columns to be computed fields.  (I
remember that we used to have that problem with a certain Btrieve driver).
In the database painter you can add for each table and columns: headers,
labels and comments to make the names more descriptive.  The comments are
visible in the sql painter.  The headers and labels are automatically used
on reports and forms.

Terry Dykstra (TeamPS)

Pete Prada wrote in message <#IljIuNC#GA.150@forums.powersoft.com>...
>Hi I have a problem when i connect to the Remedy Database.   The actual
>name's table came up like weird name.  The table's name is like H12, T 30
>then the fields in each tables like c1, c2 , c3.....
>Do you think i could be able to rename those tables and fields names to
>whatever i create, so the users can look at easily to create the reports??
>
>Thanks again
>pete
>
>


0
Terry
11/5/1998 7:19:24 PM
Thanks Terry for the pointer.

I am doing evaluation for this product and compare the Crystal Report and
Impromtu.  Have you ever experienced those products yet?  I believed that
Infomaker is pretty easy to use, but might be difficult to handle when
creating the complex report.  When running the reports, its running by
Server or Client (local PC)

Any suggestion??
pete@saionline.com
Terry Dykstra wrote in message ...
>Sounds like you have a strange ODBC driver.   It doesn't recognize the
table
>structure, so it considers all the columns to be computed fields.  (I
>remember that we used to have that problem with a certain Btrieve driver).
>In the database painter you can add for each table and columns: headers,
>labels and comments to make the names more descriptive.  The comments are
>visible in the sql painter.  The headers and labels are automatically used
>on reports and forms.
>
>Terry Dykstra (TeamPS)
>
>Pete Prada wrote in message <#IljIuNC#GA.150@forums.powersoft.com>...
>>Hi I have a problem when i connect to the Remedy Database.   The actual
>>name's table came up like weird name.  The table's name is like H12, T 30
>>then the fields in each tables like c1, c2 , c3.....
>>Do you think i could be able to rename those tables and fields names to
>>whatever i create, so the users can look at easily to create the reports??
>>
>>Thanks again
>>pete
>>
>>
>
>


0
Pete
11/5/1998 8:10:06 PM
I've never used Crystal Reports, but one of our consultants, who has
experience with Oracle Report Writer, Crystal Reports and Infomaker swears
by Infomaker.   And he is not a Powerbuilder user, but a big-time VB
developer.

Terry Dykstra (TeamPS)

Pete Prada wrote in message ...
>Thanks Terry for the pointer.
>
>I am doing evaluation for this product and compare the Crystal Report and
>Impromtu.  Have you ever experienced those products yet?  I believed that
>Infomaker is pretty easy to use, but might be difficult to handle when
>creating the complex report.  When running the reports, its running by
>Server or Client (local PC)
>
>Any suggestion??
>pete@saionline.com
>Terry Dykstra wrote in message ...
>>Sounds like you have a strange ODBC driver.   It doesn't recognize the
>table
>>structure, so it considers all the columns to be computed fields.  (I
>>remember that we used to have that problem with a certain Btrieve driver).
>>In the database painter you can add for each table and columns: headers,
>>labels and comments to make the names more descriptive.  The comments are
>>visible in the sql painter.  The headers and labels are automatically used
>>on reports and forms.
>>
>>Terry Dykstra (TeamPS)
>>
>>Pete Prada wrote in message <#IljIuNC#GA.150@forums.powersoft.com>...
>>>Hi I have a problem when i connect to the Remedy Database.   The actual
>>>name's table came up like weird name.  The table's name is like H12, T 30
>>>then the fields in each tables like c1, c2 , c3.....
>>>Do you think i could be able to rename those tables and fields names to
>>>whatever i create, so the users can look at easily to create the
reports??
>>>
>>>Thanks again
>>>pete
>>>
>>>
>>
>>
>
>


0
Terry
11/6/1998 4:28:24 PM
Terry,  I have a Sqlany5.5 Database and use Crystal reports I also have
infomaker but Rarely used It I just started and I would have to say that
Crystal is much easier to use and Would probably do better on the reporting
side.  Infomaker allows data manipulation probably better.  But If you are
going for the look on the reports I would probably suggest Crystal.  Good
luck

Pat Wright
Easy Dental Systems
Heat Database Specialist.
Pwright@easydental.com

Pete Prada wrote in message ...
>Thanks Terry for the pointer.
>
>I am doing evaluation for this product and compare the Crystal Report and
>Impromtu.  Have you ever experienced those products yet?  I believed that
>Infomaker is pretty easy to use, but might be difficult to handle when
>creating the complex report.  When running the reports, its running by
>Server or Client (local PC)
>
>Any suggestion??
>pete@saionline.com



0
Pat
11/11/1998 3:45:21 PM
Reply:

Similar Artilces:

how to control a RadioButtonList's Listitem's text show according database's field
Hi my page has a repeater control,in repeater has a RadioButtonList control now i want to let the RadioButtonList has four Listitem,every Listitem's text is a database's field so the listitem can show dynamic according every record how can i work out my problem thanks a lot  hello dearbound your RadioButtonList to database if i m not clear fell free 4 replySatyabrat SinghB.E.(C.Sc.)Web developer Livetek Solution Dont forget to click "Mark as Answer" on the post that helped you. yes.i bound the radiobuttonlist to a dataset but how to display the ...

The Microsoft Jet database engine cannot find the input table or query 'table name'. Make sure it exists and that its name is spelled correctly.
I have an access database linked to the contacts folder of outlook. I used the access link table wizard to do so. I am able to view the table in access. However, when Im trying to access the table in my .net application, i get: The Microsoft Jet database engine cannot find the input table or query 'IPContacts'. Make sure it exists and that its name is spelled correctly.  Where my table is called IPContacts. The outlook contacts folder is part of our excahnger server. When I tried to link directly to the exchange server, Access crashed. THe only look that worked was through outlook...

Is it possible to rename 'OS' field name to 'Category' on enter_bug.
Hello All, I would like to know whether (and how) is possible to change the 'OS' label to 'Category' on these screens in bugzilla: - enter_bug.cgi - post_bug.cgi - query.cgi - buglist.cgi Thank you for your time. DanielD ...

how to get a control ID from a bind field name / bound field (column) name from a formview's control
I have a form view which is bound to a table, now from codebehind file I need to apply some formatting based on some of the field's bound control. For example, if Formview1 is bound to Employee table, and it's item template has a control with ID "Label1" which is bound to "EmployeeJoinDate" . Now, I have a different table which has a list of field name(EmployeeJoinDate is one of them), all of which should be applied some formatting based on some condition. Now I can take two approach for that, but I am stuck at both:  1. If I can somehow get the contro...

What's the setup for multiple unique domain names, multiple databases, one core of DNN DLL's?
I am planning to setup a shared hosting structure for hosting DNN for different sites. The sites are independent, they should not have access to files that affect each other, multiple SQL Server databases seem  a better way than a single one for easy database restores. Admin for each site is unique and they should not share anything from the admin area. Basically each site owner logs in to their own site, manages it without knowing/affecting anything about any other site or user. Me as a server admin, I just want to log in and create a new portal/site whenever a site needs o...

Many db's / few tables vs. Few Db's / many tables
Our infrastructure group had a consultant come in for an eval. Currently, one development group who support many different groups create a database per group (sales, etc). The consultant said that this was inefficient, and that we should combine all of the databases into one database. The Infrastructure group now wants us to use one db for everything. Does anyone have any thoughts on the advantages / disadvantages of these approaches. It depends what "everything" is.  If you are mixing sales data, manufacturing data, security data, then I would still create a number of sma...

How to add link from one table's colum onto the other table's column?
I have 2 tables in a DataSet and have a link on them. I intend to put one column's content in one table, let's say t1, as the other column's link in the other table, let's say t2. However, after the link is created what I got is the t2's string in the link not the t1's. Here is my code: In the aspx: DataNavigateUrlFormatString="http://someweb.com/site/{0}" In the VB:'Create the link variableDim link As System.Web.UI.WebControls.HyperLinklink = DirectCast(e.Item.Cells(1).Controls(0), System.Web.UI.WebControls.HyperLink) 'Binding the link onto the column of Agency NameDim dr As Da...

Open file in browser or application getting the page's name as the file's name
Hi, I'm am trying to get a file to open in either a browser or application depending on the mime type. I'am using the following code in the page load. protected void Page_Load(object sender, EventArgs e){ if (!IsPostBack)    { DocumentInfo document = (DocumentInfo)Session["View_Document"]; StreamFile(document.Document, document.DocumentName, document.FileType.MimeType); } } }private void StreamFile(byte[] fileData, string originalFileName, string mimeType) { try { Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("Con...

Using Custom Tables in Other Database instead of DNN's database
Hi, I've developed some modules and as a requerimient of security department I need to put all modeles tables in other database instead of DNN database.In my Custom Modules's DataProvider class I get a different data provider (Example: I get mydata instead of data). That it work fine and I'm accessing to my own databse.Now I need to create thezip to install modeles. The problem is that I don't know what I need to put in the SqlProvider script to install create the tables and stored procedures in my database instead of DNN's database.Anybody can Help me to create the right sql script??Regards...

how to insert 'EH&S' into table in a varchar field
I am trying to update Varchar field and want to insert EH&S insted of EHS here is my code Set define off; update table1 set name='EH&S' where name='EHS' when i run this query it popup the window and ask for enter value for S. Can anyone help me for this issue?  kp  update table1 set name='EH' || '&' || 'S' where name='EHS' i did this but still it asks for enter value of S  UPDATE table1 SET NAME='Removal from work area by 'EH'||'&'||'S'' WHERE NAME='Rem...

DataGrid cant bind to type's fields only Database fields???
I'm directly binding to a webservice call (generated by VS.Net) and the datagrid says it cant find the "FIELD" or property to bind against... did you guys leave out reflecting Fields on Types? ANd if So, am I seriously gonna have to go into the autogenerated code and change every stupid Field into a Property ???----E.NewtonASP.Net/C# Solutions Developer and ConsultantEnsoft Software http://www.ensoft-software.com/eric@ensoft-software.com.cc (Remove the CC)...

why can't i reference DataSet's tables by names??
hi, i have a stored procedure like thisSelect column1 AS A column2 AS B From table AS MyTableAnd in my code i can reference the columns with their alias mylistbox.DataValueField = "A";mylistbox.DataTextField   = "B";But i cannot reference the table with the alias...when i do this in my code dtMyTable = ds.Tables["MyTable"];i will get a null reference exception    What are you using to fill your dataset?  If you are using the DataAdapter.Fill() method, there is an overloaded method where you can pass in the name of the source table, which should name the table tha...

multiple SMTP's and different IP's, domain names to send email from this server using different SMTP's
Is anybody can help me with this 2 issues we have: 1. We need to have multiple SMTP's installed on our server - how do you do that 2. We need to rotate different IP's, domain names to send email from this server using different SMTP's          Thanks   Third party mail server.  Look at Smartermail or iMail, Exchange if you need that much. JeffPlease: Don't forget to click "Mark as Answer" on the post that helped you. That way future readers will know which post solved your issue. Is this only option? &n...

superreview requested: [Bug 344505] role="anything" on <table> should remove roleless <td>'s, <th's> from hierarchy : [Attachment 229522] Any role on a table means the table structure descendants are
Aaron Leventhal <aaronleventhal@moonset.net> has asked for superreview: Bug 344505: role="anything" on <table> should remove roleless <td>'s, <th's> from hierarchy https://bugzilla.mozilla.org/show_bug.cgi?id=344505 Attachment 229522: Any role on a table means the table structure descendants are no longer structurally relevant, unless they have their own role. They're being used to layout the container. https://bugzilla.mozilla.org/attachment.cgi?id=229522&action=edit ...

Web resources about - Am I able to rename the table or field's name from database - sybase.infomaker.general

Resources last updated: 12/2/2015 9:44:42 AM