SQL Anywhere database - Delete rows in proxy table

Author

Delete rows in proxy table

Ashish

2005-04-21, 8:23 pm

Is there a way to issue delete on proxy table?

Breck Carter [TeamSybase]

2005-04-22, 7:23 am

On 21 Apr 2005 14:52:08 -0700, Ashish wrote:

>Is there a way to issue delete on proxy table?

Did you try DELETE?

Breck

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Ashish Gupta

2005-04-22, 11:23 am

Delete give me the following error message. I am issuing
delete from the database where I defined the proxy table.
Delete works fine if I am connected to remote database.

Error Message:
------------------
Server 'fpcsupplemental': [Sybase][ODBC Driver][Adaptive
Server
Anywhere]Syntax error near '(end of line)' on line 1
SQLCODE=-660, ODBC 3 State="HY000"

> On 21 Apr 2005 14:52:08 -0700, Ashish wrote:
>
>
> Did you try DELETE?
>
> Breck
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
>
http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Chris Keating \(iAnywhere Solutions\)

2005-04-22, 8:23 pm

Provided you have permissions to do so....

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

********************
********************
********************
*****************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

********************
********************
********************
*****************

<Ashish> wrote in message news:42682088.79c.1681692777@sybase.com...
> Is there a way to issue delete on proxy table?

Chris Keating \(iAnywhere Solutions\)

2005-04-22, 8:23 pm

What is the specific delete syntax that you are using?

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

********************
********************
********************
*****************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

********************
********************
********************
*****************

<Ashish Gupta> wrote in message news:426920d3.5eb4.1681692777@sybase.com...[color=darkred]
> Delete give me the following error message. I am issuing
> delete from the database where I defined the proxy table.
> Delete works fine if I am connected to remote database.
>
> Error Message:
> ------------------
> Server 'fpcsupplemental': [Sybase][ODBC Driver][Adaptive
> Server
> Anywhere]Syntax error near '(end of line)' on line 1
> SQLCODE=-660, ODBC 3 State="HY000"
>
>
> http://www.amazon.com/exec/obidos/A...7/risingroad-20

Ashish Gupta

2005-04-25, 11:23 am

Chris,

I am using most simplistic form of delete on proxy table. If
my proxy table name is ABC on base databases with primary
key as 1, my delete statement looks like this

Delete from ABC where abc_id = 1;

Where ABC is defined as proxy table in the database on XYZ
table on remote database. The insert and update works fine
on proxy table but delete fails.

If I issue the same delete statment while directly connected
to remote database, the above statement works fine. I am
using ASA 9.02 as base database and remote database.

Any directions will be very helpful and very appreciative

> What is the specific delete syntax that you are using?
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> ********************
********************
******************
> ******************* Sign up today for your copy of the SQL
> Anywhere Studio 9 Developer Edition and try out the
> market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
> ********************
********************
******************
> *******************
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at
> http://www.iAnywhere.com/developer ** EBFs can be found at
> http://downloads.sybase.com/swx/sdmain.stm ** Use
> CaseXpress to report bugs http://casexpress.sybase.com
>
> ********************
********************
******************
> *******************
>
> <Ashish Gupta> wrote in message
> works fine if I am connected to remote database. >
>
http://www.amazon.com/exec/obidos/A...7/risingroad-20
> Services >> www.risingroad.com
>
>

Chris Keating \(iAnywhere Solutions\)

2005-04-25, 1:23 pm

I cannot reproduce this.

You'll probably need to contact Technical Support to get this issue
resolved. Within North America, you can reach Technical Support by calling
1-800-8SYBASE. If you are located outside of North America, you can find
the contact information for your local Sybase Support Center by going
to the Sybase home page at http://www.sybase.com, clicking on the "Support"
link at the top of the page, and then choosing "Support Centers" from the
left hand frame.

You can always report a bug for free by visiting CaseXpress at
http://casexpress.sybase.com/cx/cx.stm. When submitting calls through
CaseXpress,
please make sure to give an accurate description of the steps you take to
reproduce the bug, and include any files that may be needed (database,
source code) to reproduce the problem.

<Ashish Gupta> wrote in message news:426d0e6c.141a.1681692777@sybase.com...[color=darkred]
> Chris,
>
> I am using most simplistic form of delete on proxy table. If
> my proxy table name is ABC on base databases with primary
> key as 1, my delete statement looks like this
>
> Delete from ABC where abc_id = 1;
>
> Where ABC is defined as proxy table in the database on XYZ
> table on remote database. The insert and update works fine
> on proxy table but delete fails.
>
> If I issue the same delete statment while directly connected
> to remote database, the above statement works fine. I am
> using ASA 9.02 as base database and remote database.
>
> Any directions will be very helpful and very appreciative
>
>
>
> http://www.amazon.com/exec/obidos/A...7/risingroad-20

Sponsored Links