2. ASPRunnerPro General questions
  3. edit joined table question
This topic is locked

edit joined table question

 		12/29/2011 2:11:57 PM
ASPRunnerPro General questions
author

My Database is SQL Server 2005.

I hava tow tables, like this:

table1:student

ID:int

Name:nchar

SexID:nchar

PIC:image
table2:SexID

ID:nchar

SEX:nchar
My SQL with join is

SELECT

dbo.Student.ID,

dbo.Student.Name,

dbo.Student.Pic

dbo.Sex.Sex,

FROM dbo.Student

LEFT OUTER JOIN dbo.Sex ON dbo.Student.SexID = dbo.Sex.ID
Now, I want edit the joined talbe, like change Name, PIC, Sex in edit page. But it doesn't work, system info is "you couldn't edit two tables". I try use events, but no way.
Could you tell me how...
Sergey Kornilov admin 12/29/2011

In regards to updating multiple tables I suggest to check this article:

http://xlinesoft.com/asprunnerpro/docs/update_multiple_tables.htm
8202 12/30/2011



In regards to updating multiple tables I suggest to check this article:

http://xlinesoft.com/asprunnerpro/docs/update_multiple_tables.htm


The first, thank you for you answer.

But, "http://xlinesoft.com/asprunnerpro/docs/update_multiple_tables.htm" could not solve my problem.

As you know, there is a image field in my "Student" table, means that, it should own upload image function in events.

Now, my question is how to upload image to SQL Server DB by coding in events of ASPRunner. Not PHPRunner.
Sergey Kornilov admin 12/30/2011

You do not need to code any events. Simply set 'Edit as' type of the field that would store the file name to 'File/Image'.