×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

SyntaxFormSql

SyntaxFormSql

SyntaxFormSql

(OP)
I'm trying to build a grid datawindow using SyntaxFormSql. The user is not sa. I cannot get the correct syntax. How can i do ?

RE: SyntaxFormSql

What have you tried so far? What kind of messages (if any) are you getting?

Matt

"Nature forges everything on the anvil of time"
www.anvil-of-time.com

RE: SyntaxFormSql

(OP)
Matt,

I using SyntaxFromSQL by not sa user. The column text is different from pbcatcol.pbc_hdr.

Thanks.

RE: SyntaxFormSql

(OP)
Matt,

When user is sa I got this.
"retrieve="select * from cust_stk_brand"
update="cust_stk_brand" updatewhere=1)
header(height=92)
detail(height=104)
column(band=detail id=1 x="14" y="8" height="76" width="293" tabsequence=10 edit.limit=10 alignment="0" tag="客戶代號"font.face="Arial" font.height="-12" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" )"


When user is not sa I got this,and I can't update data.
"retrieve="select * from cust_stk_brand")
header(height=68)
detail(height=80)
column(band=detail id=1 x="14" y="8" height="64" width="251" edit.limit=10 alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no )"


I need to update data and user is not sa. How can I do?


Many thanks!


RE: SyntaxFormSql

I am confused. How are you building the SQL statement you send to the SyntaxFromSQL method? Also, what is the presentation string?

Matt

"Nature forges everything on the anvil of time"
www.anvil-of-time.com

RE: SyntaxFormSql

(OP)
Matt,

My syntax like this.

"sql_syntax = 'select * from ' + this.object.pbt_tnam[currentrow]
ls_type = 'grid'
presentation_str = "style(type=" + ls_type + ")"
dwsyntax_str = SQLCA.SyntaxFromSQL(sql_syntax,presentation_str, ERRORS)
"

Thanks.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close