Hello,
Could anyone please tell me how to write data in a text field which is greater then 8000 in size. The problem is that writetext function overrides the data and accepts string as argument and not select statement or any other thing as argument.
So could anybody please illustrate with an example.
Pleaseeeeeeeeee eeeeeee
Thanks in advance.
uzairahm
Last Activity: Sep 4 '07, 06:20 PM
Joined: Jun 27 '07
Location:
-
Wrtting to the text field
-
retrievng text or ntext data from column whose data type is ntext/text
Hello,
In order to retrieve data from text type column whose length is greater then 4000 (for text) the data is being truncated i have tried using readtext through textptr, substring set textsize and all the related stuff i could find on books online but nothing did the job. The results from all these techniques return only 4000 length data and nothing greater.
Can anyone please help me with it. An example along with... -
Hey, I have Firewall disabled. This is not the issue of Firewall I think so. I have checked the port 445 is open. Please anyone else there with an idea -
Well through new feature of SQl Server 2005 which is Pivot this issue could easily be solved. Don't wanna spoil u'r fun by telling u the exact solution. Hope you will figure it out if you can't tell me then surely i will tell u the exact solution.Leave a comment:
-
Thanks guys for redirecting me. But it seems that there is no answer for me even at the right place. Anyway thanks fellaws.
Hope to listen soon from ppl of the forum i reply to my query. I really need help as i am really stuck and i don't know the solution one obvious sollution is to install MS Server 2000/2003 OS but i don't wanna do that please could anyone tell me the solution??????? ??????????????? ??????????????? ???????????????...Leave a comment:
-
MS SQL Server 2005 On Microsoft XP No DataBase Server
Hello Guys,
I have recently installed MS SQL Server 2005 On Microsoft XP. Before Installation there wre no Messages in system compatablity check. But after installation it hasn't created any Server or System databases ,ike master, tempdb etc. Need help !!!!!1 -
weel the input is through form where the record for Procedures is added.
And i entered the update sql as Queries not as procedure.
What would be the method of running this query. Should i ammend it with insertproc query if so show should it be ammended.
regards,
UzairLeave a comment:
-
Thanks a lot i figured it out. I kept FiscalYear's DataType as Text and my problem is solved Thank You so much.Leave a comment:
-
Thanks for u'r intrest.
I am real novice to Access so could you please tell me how would i be able to run the below sql you mentioned
UPDATE Procedures SET FiscalYear = IIf(Month([OpDate])>3, """ & Year([OpDate]) & "/" & Year([OpDate])+1 & """, """ & Year([OpDate])-1 & "/" & Year([OpDate]) & """);
...Leave a comment:
-
Hi itazz
I am also looking for a solution for retrieving data as fiscal year (april- march)
could you please guide me the solution.
i have stored date in a date field type
thanks...Leave a comment:
-
Fiscal Year
Hi!
I wanted to modify the query the query is given below.
SELECT Format([OpDate],"yyyy") AS [Year], ProcFees.ProcNa me, Count(ProcFees. ProcName) AS CountOfProcName
FROM ProcFees INNER JOIN (Procedures INNER JOIN ProcDetails ON Procedures.[Order ID] = ProcDetails.[Order ID]) ON ProcFees.[Proc ID] = ProcDetails.[Proc ID]
WHERE ProcFees.ProcNa me<>"General Anaesthetic" And ProcFees.ProcNa me<>"Local...
No activity results to display
Leave a comment: