SQL: Column names, can ONLY get "name" instead of "table.name"
When iterating through column names returned from a query, I need to get "table.name" rather than just "name"
Check it out:
If I have an SQL statement "SELECT table1.ID, table2.ID FROM table1, table2;"
And table1 has a column name 'ID'
and table2 has a column name 'ID' aswell,
and i run the query, the dataset will contain column names 'ID' and 'ID'
instead of 'table1.ID' and 'table2.ID'
It is extremely important that I can differenciate between the 2 fields, and know where each of them come from.
The same thing happen...How do I get rid of the quoted table names and column names? #2
I have reversed Engineered an Access 2000 DB File, then changed the Database
type from Access 2000 to Oracle 9i. The table and column names all have
double quotes around them.
create table "Table_59" (
Why did this happen and How do I get rid of the double quotes?
In the ...column "name" is not in table "name "
I have a problem with PB 6.5.1, and Informix 5.02 (Online) ...
We receive the error above in subject.... when i tried to make a
updated. (settings) .. I`m not sute what that mean..
I have done all the testing.. and I did not find anything...Please ..
It sounds like the datawindow has a select statement that selects data from
multiple tables using a SQL Join. nd perhaps when the update properties were
set, columns from multiple tables were selected and marked as updateable
I will test this when I get a ...How to get rid of the table name prefix in column names
This is driving me up the wall.
I have a pfc application where I log in to an Adaptive Server Anywhere 8
database using the pfc functions. In this app I have a function where I create a
datastore, do a retrieve and then loop through the rows fetching the column
names as follows:
s_name = lower(ds_export.Describe("#" + String(i_col) + ".Name"))
This works fine.
Now I want to run this function as a standalone program. So I create a simple
non-pfc application and copy the code to a new function adding log-in code. This
also works fine. Except....
N...How to use a full column name (table name and column name) with a DataReader
Hi, I have a problem retrieving the data with a DataReader from a stored proc that performs a join of two table with the same column's names but different data.
Let me explain with an example:
I have two tables:
Table1: Id, Name
Table2: Id, Name, IdTable1
The sproc is something like this:
CREATE PROCEDURE [dbo].[SearchByName]
FROM dbo.Table1, dbo.Table2
WHERE Table1.Id = Table2.IdTable1
AND Table1.Name LIKE '%' + @Name + '%'
And my c# code is something like this:
Database db = Databas...Trying to put dw.SetItem (ll_Row, "Column Name", dw.GetItemDec (ll_Row, "Column Name for CF"))
hello for some reason, it seems like my strings from
yesterday doesnt come up on this newsgroup list. Anyways..
my problem is to put
dw.SetItem (ll_Row, "Column Name", dw.GetItemDec (ll_Row,
"Column Name for CF")).
so that i can give a column value and a computed field so
the data i give through the computed field gets inserted in
1. where in the code do i put this..
2. i have a global function which i called with a computed
field "Column Name for CF".. tried attaching the pbl but no
luck cany anyone help me please.. this is very critical f...how to get table and columns names in quotes
I am using PowerDesigner 22.214.171.1249 for an existing Sybase Anywhere 6
database. I have reversed engineered the database. Unfortunately some of
the column names are reserved words such as "comment". When I generate the
script and try to run the script it will error out. If there were quotes
around the table and column names it would not error out. How can I get it
to use quotes around table names and column names in the script? Thanks
for the help.
First I suggest that you upgrade to 7.5.0 at the very least. The
patch is available at http://www.sybase.com.
I am using PowerBuilder 9.0 Build 5507.
1) From within Powerbuilder, click File->New. Click the DataWindow Tab and
double-click on the FreeForm icon.
2) From the "Choose Data Source for FreeForm DataWindow" dialog window,
select the "SQL Select" icon and click "Next".
3) From the "Select Tables" dialog window, I selected the table MYTABLE, and
then I selected the first 10 fields in that table.
4) Continue creating the form using the default values.
5) In the Column Specifications tab, there is a "DB Name" column which ...IM 9.0
I am using InfoMaker 9.0 Build 5507.
In my PBL file, I create a new Freeform object.
Then I choose SQL Select to select the table and the columns. In the
Reports view, in the Column Specifictions tab, there is a "DB Name" column
which shows the column name in "table_name.column_name" format. When a
column name ends with a number (i.e. street1), the table name does not get
prefixed in the Column Specification tab. For example, it displays
"street1" instead of "mytable.street1".
Has anyone else encountered this problem before?
Please h...Whan can i do? make "string" data type convert to "window" data type, and use a "window" name to get it ancestor "window name", thanks! i use pb5
With a string window name, you can open a window of that type if you need
to. You could, of course, query that window object for any attributes.
Another option is to use the LibraryExport function to export the definition
of the window which is specified by the string. You can then parse the
resulting file to get information on the ancestor object.
"Rich" <firstname.lastname@example.org> wrote in message
...META name="title" + META name="description" + META name="keywords" in MasterPage head section
I've placed these META tags on the HEAD section of my MASTERPAGE of my application (used in all my webforms)
Last Monday week I was on the first page of GOOGLE at the sixth position.
Last Friday, I've added a script section on my head too. Something like:
This week, I can't even find my site even if I put on the search engine te exact site name.
Did I do something wrong?
Does the scrip section stop the google robots to read the META tags?
Thank you in advance
First of all, META tags...Mail resending duplicates in the "from" field the (Given Name Last Name) if name contains a "-"
An other incredible behavior with client GW8.01 and GW8.01HP
if you resend one of your mail and if you given name or last name
contains a "-" in eDir, the from field of your email is populated with a
second occurrence of (givenname lastname); if you resend this again,
then you get it 2 times (givenname lastname)(givenname lastname)etc...
so an example:
Suppose you are Snow White, with a frenchy touch,
eDir Given Name: Blanche-Neige
eDir Last Name: Disney
and your GW address book is updated with it in first name/last name/name
Then if..."Column name or number of supplied values does not match table definition" when trying to populate temp table
I am receiving the following error:
Column name or number of supplied values does not match table definition
I am trying to insert values into a temp table, using values from the table I copied the structure from, like this:
SELECT TOP 1 * INTO #tbl_User_Temp FROM tbl_User
TRUNCATE TABLE #tbl_User_Temp
INSERT INTO #tbl_User_Temp EXECUTE UserPersist_GetUserByCriteria @Gender = 'Male', @Culture = 'en-GB'
The SP UserPersist_GetByCriteria does a
"SELECT * FROM tbl_User WHERE gender = @Gender AND culture = @Culture",
so why am I receiving this error when both tab...how to prefix column name with table name
I need to pefix column name (that is PD column code) with
the table name(..code) either at CDM to PDM generation time
or when I collapse existing PDM tables with non unique
column codes into a denormalized table.
I would like to know how to do it from both ways. please
provide as detailed as possible explanation as I am a newbie
When you generate from CDM to PDM, you have the option to prefix each
column with a Table Prefix (first 3 chars of table name). You could use
VBScript if you wanted to do more from the PDM. For instance, write a