THANK GOD WE ARE UNDERSTANDING EACH OTHER..
look the interbase (ibexpert) doesnt use sys.anything
there must be some sort of other kywords for such database...
this is my main issue. i have allready found sys.datatable_name...and stuff
but the sys is not understood by ibexpert..
i tried to google it ... i found an answer in experts exchange.com
but in order to view the answer i had to pay! and i dont have any credit cards on me...
to be honest no matter if u could help me or not i am so thankful for your support! so thankful for taking time one me like this.
i cant belive the result was under my nose all the time and i didnt see it!
thank you sebastian...
ill never forget your support!
if u got curious ...
the thing i wanted is (you type in google fetch parent child tables interbase) you will get the title article (fetch parent child... uppercased u enter it and you will find what i wanted exactly..)
thank you so much. hop this works.becos it says oracle ...
thank you again
You cannot use an IN with a variable. Either use dynamic sql or, my preferred method, use a function to split the list into a table variable and join on that. A quick google will give you examples, but here is a starter
CREATE FUNCTION [dbo].[fn_DelimitedSplit]
@TextToSplit VARCHAR(8000), @Delimiter VARCHAR(255)
RETURNS @SplitKeyword TABLE (Keyword VARCHAR(8000),seq int identity)
DECLARE @Word VARCHAR(255)
WHILE (CHARINDEX(@Delimiter, @TextToSplit, 1)>0)
SET @Word = SUBSTRING(@TextToSplit, 1 , CHARINDEX(@Delimiter, @TextToSplit, 1) - 1)
SET @TextToSplit = SUBSTRING(@TextToSplit, CHARINDEX(@Delimiter, @TextToSplit, 1) + 1, LEN(@TextToSplit))
INSERT INTO @SplitKeyword(Keyword) VALUES(@Word)
INSERT INTO @SplitKeyword(Keyword) VALUES(@TextToSplit)
Bob Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
Using Visual Web Developer Express and SQL Server 2005 on an XP development machine.
Was using development server in VWDE to view pages, using following connection string:
|add name="RHConnectionString" connectionString="server=MIKE;database=Rotary;Trusted_Connection=True;"/|
Needed to test with SSL. Installed SSL certificate (using your makecert procedure, thanks). Moved web site to IIS and opened in VWDE. Development connection to database works, but pages get Login failed for user 'MIKE\IUSR_MIKE'.
SQL Server configured for Remote Connections and mixed Windows Authentication and SQL Server authentication.
Go to your management Studio. Right click your Server and go to properties. in the Properties go to Security and look at the Options under Server Authentication. and tell us what is selected there.
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
Dont know if this may help but worth a try go to SAL Server Surface Area Configuration and then Surface are configuration for services and connections. Choose Remote connections, check Local and remote connections and choose TCP/IP only. Hope this helps
Okay, I'm new to the whole ADO.NET stuff, so don't punish me to hard if I ask a total bullshit question...
First, here's a piece of code (assume, aDataSet is already initialized and the table "aTable" also exists):
Dim aRow As DataRow
For Each aRow In Me.mDataSet.Tables("aTable").Rows
aRow.Item("isParent") = True
What I wanna do: Add the new column "isParent" to "aTable" (okay, I managed this), and initialize it with a standard value (I do this in the for-next-loop). But I thought, there must be a more elegant way to do this, without picking every single cell in a loop. Anyone know a good solution?
I don't need to write in a database, 'cause my aDataSet is build on the fly, without database representation.