i offer to have the following entity/table for your application :
1-an entity named "Session " with these fields (SessionID,Sess ionName,Session Date ) with SessionID for primary key.
2-an entity named SessionFiles with these fields(SessionI D,FilenameWithP ath,uploadStatu s) with "SessionID,File nameWithPath" for primary key.
3-make relation for these two table with SessionID field....
hoomaniraji
Last Activity: Oct 15 '07, 06:46 AM
Joined: Jul 20 '07
Location:
-
1- i think you should have a MainCatalogId in your second table.because if you have many Maincatalog you can not save relation for other Maincatalog if you have repeated code of items.
2-you must create a dataset returning storedprocedure with the columns for your output.
3-in your storedprocedure you must have three cursor with three loop for three level(suppose you have three level),each loop contains parent loop.then fetch what...Leave a comment:
-
if you do not want to programm in DTS ,then you can use enterprise manager of sql server with the following steps :
1-you should register your remote server in enterprise manager
2-you should register local server and attach the local database in the local server
3-if you have not any database on your remote server.you or your host administrator must create a database for your use.also you must have a user for accessing...Leave a comment:
-
please check these step by step :
1-your Licence for sqlserver in your host(Number of concurrent user)
2-calculate your application resource used for these number of users and compare it with your host hardware resources.if your application server and database server runs in on server.your application maybe impact on your sqlserver services[related to share resources]....Leave a comment:
-
you can use DTS(Data Transformation) In SQL Server .you can also import/export wizards in enterprise manger of sql server to do this schedually.if you want to customize the control in your application ,you must use MSSQL SDK....Leave a comment:
-
please say which version of turbo c++ : under DOS operating system or windows ?...Leave a comment:
-
i think if you use them in the same transaction.you have no problem.of course if you must use two transaction then set the 'transaction isolation level' to ''dirtyread"....Leave a comment:
-
hi
if you use this value for inserting new record in a multi user application your solution may not work.check it.Leave a comment:
-
hi
you must create ' views' or 'stored procedure with dataset returning' for each section of your select statement then you can use cast() function for changing the type of your output column in that view. then join that views or storedprocedure s in anaother select statement to output the dataset you need.Leave a comment:
-
hi
suppose you have Table1(C1,C2,C3 )
you have two solution :
1- For Static usage you can use Select Sql Statement with this format :
Select 'C1'
from Table1
where Table1.C1 = "PAL"
union
Select 'C2'
from Table1
where Table1.C2 = "PAL"
union
Select 'C3'
from Table1
where Table1.C3 = "PAL"...Leave a comment:
No activity results to display
Leave a comment: