Related topics

Indexed View - non deterministic udf
Hi, I am a VBA newbie and want to know how I go about installing a UDF that someone has sent me the code for? Is there an on-line idiot proof tutorial/explaination for this? Is it complicated? Dave ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post

ComboBox RowSourceType containing UDF => call back oddities
You can add a brief description of your UDF by going to Tools>Macro>Macros. Type in the name of your UDF and hit "Options". Add a description and hit OK then Cancel. Yes......Cancel. How can I view how the function was filled out? Thanks as always for your help...Steve Gord Dibben MS Excel MVP.

Change names of columns in a view
Douglas J. Fritz jeep4...@mindspring.com microsoft public fox vfp queries-sql I have a UDF I wrote and I want to use it in a view I'm building. When I type out the call line and add it to the fields in the view it gets enclosed in quotes and comes out as a string when I run the view. ie MyFunction(tablea.field1

UDF problems with CD-RW disks -other machines can't read them
... this was very frustrating for over 2 weeks for me and now it is ok and so can yours be......... have faith. "Brad" <sba...@hotmail.com> wrote in message news:efvSWmIZBHA.1360@tkmsftngp07... after upgrading to xp, I am unable to view my saved jpg's on cdrw's. the system says cannot read an OSTA UDF FILESYSTEM.

performance: table value UDF vs view
... microsoft public windowsxp basics microsoft public windowsxp customize Nero Burning will do it. "Brad" <sba...@hotmail.com> wrote in message news:efvSWmIZBHA.1360@tkmsftngp07... after upgrading to xp, I am unable to view my saved jpg's on cdrw's. the system says cannot read an OSTA UDF FILESYSTEM. help!!!!!!!!!!1.

Why prohibit in UDF?
Marcydb ============================================= Maybe the following KB article will be useful: (321640) CD-ROM Drive May Not Be Able to Read a UDF-Formatted Disc in Windows XP http://support.microsoft.com/?kbid=321640 Free...Adaptec UDF Reader Driver 5.1.1.213 http://download.com.com/3000-2100-9497911.html

UDF in view
Could it be that my Windows doesn't understand UDF 2.0? Is there any driver or software that can bridge this gap? Another somewhat related question: If I have a When you're finished editing, you can use MEDIASTUDIO's built-in DVD-VR export wizard to 'burn' the edited MPEG back to a DVD-RAM disc for viewing in a

Bulgaria: leader of ethnic Turks accuses premier of creating ...
The values for the 4 account balance columns are calculated by the UDF I've been mentioning. I then created a View with two columns, Customer ID and the first balance type. I queried the table for a specific Customer ID and the first balance. In the same query batch, I ran a query against the View with the same

rowset concatenation problem: view vs. table
That being the case, as root, use the command "mount -t udf /dev/cdrom /mnt/cdrom". At present you're mounting a small ISO partition which is also on the A cuter way to do the same is to create a second mount point, such as /mnt/cdrw and add the following line to /etc/fstab: /dev/cdrom /mnt/cdrw udf noauto,user

viewing burned cd's on two different systems
Neil W ne...@REMOVEnetlib.com microsoft public sqlserver security Lets say I have a view, MyView, that calls MyUDF and/or MyExtendedProcedure. Is there a way I can allow a user to access MyView, but stop them from directly executing MyUDF or MyExtendedProcedure? Eg, I'd like them to be able to do this: select

SQLServer 2000 View/UDF Question
Why DB2 optimizer desides to materialize the result set on all the view's colums (c1 and c3 in this case) instead of just simply rewriting the SQL to select c1 from t? Because you told DB2 that it must do that. Your UDF is defined (implicitly) with EXTERNAL ACTION, so DB2 must ensure that the UDF is called exactly

Viewing DVD-RAM with Archos DVD USB
Why DB2 optimizer desides to materialize the result set on all the view's colums (c1 and c3 in this case) instead of just simply rewriting the SQL to select c1 from t? Well...it's not an issue in that basic case, but in production the table like "t" is going to be very large and the real UDF like "flw" implements a

Installing someone elses UDF
The problem is that sql server seems to be determining that the UDF is non-deterministic and therefoer i cannot create the index. could anyone point me to where i could find information exaplaining the criteria sql server uses to determine if a UDF is non-deterministic?

Create dynamic denormalized view
Anthony On 15 Mar 2006 13:35:24 -0800, JTim wrote: We have inherited a system where alot of User Defined Types >and Views are used. As you know UDF's are created >> because >of their reusablility. Is there a way in Power Designer, after I reverse Engineer >the database to query a udf or view in such a way that it

protect/hide stored procedure/view/udf code
So what is UDF about? Use a different tool that does not create a proprietary format by encapsulating the data, requiring a Windows program to view/access. On the chance that the file format is zip, have you tried unzip? Bill JohnSutherl...@nospam.thanks wrote: I employed a windoze machine to copy some data files

Access a UDF from Crystal?
ItemId LEFT JOIN UDF ON ID.UDFId = UDF.UDFId GROUP BY I.ItemId, I.Name Now, your subject line talks about a dynaimc view, and that users can define as many fields they want. To handle that you need to use dynamic SQL. To saved that diry work, it could be worth checking out http:://www.rac4sql.net for a third-party

View or Table with UDF defined Columns
JE McGimpsey jemcgimp...@mvps.org microsoft public excel misc one way, using an event macro (worksheet functions and UDFs can't do this since they can only return values to their calling cells): Put this in the Sheet2 worksheet code module (right-click on the worksheet tab, choose View Code, paste the code in the

View or Table with UDF defined Columns
Thomas Steinmaurer t...@iblogmanager.com borland public interbase sql Without analyzing your view in detail, have you tried the query the view with another tool Created the view, but something is wrong with it. It shows fine in the Views tab, but when trying to see the data with the data tab IBConsole crashes.

How many times has a UDF been called?
An inline table UDF is not a really a function - it is a macro which is pasted into the query, and the query processor considers the expanded query. Neither are there any considerable performance penalty with multi-step table UDF - at least if not if the alternative is to first populate a temp table.

viewing saved pics on cdrw's (prob)
-----Original Message----- Answer yes to install UDF reader. "Gilbert" <anonym...@discussions.microsoft.com> wrote in message Everytime I put it in it asks me if I want to install the UDF Reader? Please help. Also, it was a CD-R and I'm not sure how it was burned before. What I'm thinking is that my computer